eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WIP_ENTITIES_UTIL dependencies on FND_API

Line 19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN

15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN
18:
19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

Line 27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

Line 59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

Line 67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;
77: END IF;
78:
79: RETURN l_Wip_Entities_rec;

Line 92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN

88: IS
89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN
91:
92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

Line 100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

Line 132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

Line 140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
149: l_Wip_Entities_rec.wip_entity_name := NULL;
150: END IF;
151:
152: RETURN l_Wip_Entities_rec;

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: , 'Update_Row'
192: );
193: END IF;
194:
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196:
197: END Update_Row;
198:
199: -- Procedure Insert_Row

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: , 'Insert_Row'
251: );
252: END IF;
253:
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255:
256: END Insert_Row;
257:
258: -- Procedure Delete_Row

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278: , 'Delete_Row'
279: );
280: END IF;
281:
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283:
284: END Delete_Row;
285:
286: -- Function Query_Row

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339: , 'Query_Row'
340: );
341: END IF;
342:
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344:
345: END Query_Row;
346:
347: -- Procedure lock_Row

Line 433: x_return_status := FND_API.G_RET_STS_SUCCESS;

429: x_Wip_Entities_rec := l_Wip_Entities_rec;
430:
431: -- Set return status
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: ELSE
437:

Line 434: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_SUCCESS;

430:
431: -- Set return status
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: ELSE
437:
438: -- Row has changed by another user.

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: ELSE
437:
438: -- Row has changed by another user.
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
442:
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN

Line 441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

437:
438: -- Row has changed by another user.
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
442:
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN
445:

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: EXCEPTION
453:
454: WHEN NO_DATA_FOUND THEN
455:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN

Line 457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

453:
454: WHEN NO_DATA_FOUND THEN
455:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461:

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464:
465: END IF;
466: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
470:
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN

Line 469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

465: END IF;
466: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
470:
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

476:
477: END IF;
478: WHEN OTHERS THEN
479:
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN

Line 481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

477: END IF;
478: WHEN OTHERS THEN
479:
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg