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_RES_UTIL dependencies on FND_API

Line 17: IF l_Res_rec.acct_period_id = FND_API.G_MISS_NUM THEN

13: IS
14: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type := p_Res_rec;
15: BEGIN
16:
17: IF l_Res_rec.acct_period_id = FND_API.G_MISS_NUM THEN
18: l_Res_rec.acct_period_id := NULL;
19: END IF;
20:
21: IF l_Res_rec.activity_id = FND_API.G_MISS_NUM THEN

Line 21: IF l_Res_rec.activity_id = FND_API.G_MISS_NUM THEN

17: IF l_Res_rec.acct_period_id = FND_API.G_MISS_NUM THEN
18: l_Res_rec.acct_period_id := NULL;
19: END IF;
20:
21: IF l_Res_rec.activity_id = FND_API.G_MISS_NUM THEN
22: l_Res_rec.activity_id := NULL;
23: END IF;
24:
25: IF l_Res_rec.activity_name = FND_API.G_MISS_CHAR THEN

Line 25: IF l_Res_rec.activity_name = FND_API.G_MISS_CHAR THEN

21: IF l_Res_rec.activity_id = FND_API.G_MISS_NUM THEN
22: l_Res_rec.activity_id := NULL;
23: END IF;
24:
25: IF l_Res_rec.activity_name = FND_API.G_MISS_CHAR THEN
26: l_Res_rec.activity_name := NULL;
27: END IF;
28:
29: IF l_Res_rec.actual_resource_rate = FND_API.G_MISS_NUM THEN

Line 29: IF l_Res_rec.actual_resource_rate = FND_API.G_MISS_NUM THEN

25: IF l_Res_rec.activity_name = FND_API.G_MISS_CHAR THEN
26: l_Res_rec.activity_name := NULL;
27: END IF;
28:
29: IF l_Res_rec.actual_resource_rate = FND_API.G_MISS_NUM THEN
30: l_Res_rec.actual_resource_rate := NULL;
31: END IF;
32:
33: IF l_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 33: IF l_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN

29: IF l_Res_rec.actual_resource_rate = FND_API.G_MISS_NUM THEN
30: l_Res_rec.actual_resource_rate := NULL;
31: END IF;
32:
33: IF l_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
34: l_Res_rec.attribute1 := NULL;
35: END IF;
36:
37: IF l_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 37: IF l_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN

33: IF l_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
34: l_Res_rec.attribute1 := NULL;
35: END IF;
36:
37: IF l_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN
38: l_Res_rec.attribute10 := NULL;
39: END IF;
40:
41: IF l_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 41: IF l_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN

37: IF l_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN
38: l_Res_rec.attribute10 := NULL;
39: END IF;
40:
41: IF l_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN
42: l_Res_rec.attribute11 := NULL;
43: END IF;
44:
45: IF l_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 45: IF l_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN

41: IF l_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN
42: l_Res_rec.attribute11 := NULL;
43: END IF;
44:
45: IF l_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN
46: l_Res_rec.attribute12 := NULL;
47: END IF;
48:
49: IF l_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 49: IF l_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN

45: IF l_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN
46: l_Res_rec.attribute12 := NULL;
47: END IF;
48:
49: IF l_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN
50: l_Res_rec.attribute13 := NULL;
51: END IF;
52:
53: IF l_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 53: IF l_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN

49: IF l_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN
50: l_Res_rec.attribute13 := NULL;
51: END IF;
52:
53: IF l_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN
54: l_Res_rec.attribute14 := NULL;
55: END IF;
56:
57: IF l_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 57: IF l_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN

53: IF l_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN
54: l_Res_rec.attribute14 := NULL;
55: END IF;
56:
57: IF l_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN
58: l_Res_rec.attribute15 := NULL;
59: END IF;
60:
61: IF l_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 61: IF l_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN

57: IF l_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN
58: l_Res_rec.attribute15 := NULL;
59: END IF;
60:
61: IF l_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN
62: l_Res_rec.attribute2 := NULL;
63: END IF;
64:
65: IF l_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 65: IF l_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN

61: IF l_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN
62: l_Res_rec.attribute2 := NULL;
63: END IF;
64:
65: IF l_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN
66: l_Res_rec.attribute3 := NULL;
67: END IF;
68:
69: IF l_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 69: IF l_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN

65: IF l_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN
66: l_Res_rec.attribute3 := NULL;
67: END IF;
68:
69: IF l_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN
70: l_Res_rec.attribute4 := NULL;
71: END IF;
72:
73: IF l_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 73: IF l_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN

69: IF l_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN
70: l_Res_rec.attribute4 := NULL;
71: END IF;
72:
73: IF l_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN
74: l_Res_rec.attribute5 := NULL;
75: END IF;
76:
77: IF l_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 77: IF l_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN

73: IF l_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN
74: l_Res_rec.attribute5 := NULL;
75: END IF;
76:
77: IF l_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN
78: l_Res_rec.attribute6 := NULL;
79: END IF;
80:
81: IF l_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 81: IF l_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN

77: IF l_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN
78: l_Res_rec.attribute6 := NULL;
79: END IF;
80:
81: IF l_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN
82: l_Res_rec.attribute7 := NULL;
83: END IF;
84:
85: IF l_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 85: IF l_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN

81: IF l_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN
82: l_Res_rec.attribute7 := NULL;
83: END IF;
84:
85: IF l_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN
86: l_Res_rec.attribute8 := NULL;
87: END IF;
88:
89: IF l_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 89: IF l_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN

85: IF l_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN
86: l_Res_rec.attribute8 := NULL;
87: END IF;
88:
89: IF l_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN
90: l_Res_rec.attribute9 := NULL;
91: END IF;
92:
93: IF l_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 93: IF l_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN

89: IF l_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN
90: l_Res_rec.attribute9 := NULL;
91: END IF;
92:
93: IF l_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN
94: l_Res_rec.attribute_category := NULL;
95: END IF;
96:
97: IF l_Res_rec.autocharge_type = FND_API.G_MISS_NUM THEN

Line 97: IF l_Res_rec.autocharge_type = FND_API.G_MISS_NUM THEN

93: IF l_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN
94: l_Res_rec.attribute_category := NULL;
95: END IF;
96:
97: IF l_Res_rec.autocharge_type = FND_API.G_MISS_NUM THEN
98: l_Res_rec.autocharge_type := NULL;
99: END IF;
100:
101: IF l_Res_rec.basis_type = FND_API.G_MISS_NUM THEN

Line 101: IF l_Res_rec.basis_type = FND_API.G_MISS_NUM THEN

97: IF l_Res_rec.autocharge_type = FND_API.G_MISS_NUM THEN
98: l_Res_rec.autocharge_type := NULL;
99: END IF;
100:
101: IF l_Res_rec.basis_type = FND_API.G_MISS_NUM THEN
102: l_Res_rec.basis_type := NULL;
103: END IF;
104:
105: IF l_Res_rec.completion_transaction_id = FND_API.G_MISS_NUM THEN

Line 105: IF l_Res_rec.completion_transaction_id = FND_API.G_MISS_NUM THEN

101: IF l_Res_rec.basis_type = FND_API.G_MISS_NUM THEN
102: l_Res_rec.basis_type := NULL;
103: END IF;
104:
105: IF l_Res_rec.completion_transaction_id = FND_API.G_MISS_NUM THEN
106: l_Res_rec.completion_transaction_id := NULL;
107: END IF;
108:
109: IF l_Res_rec.created_by = FND_API.G_MISS_NUM THEN

Line 109: IF l_Res_rec.created_by = FND_API.G_MISS_NUM THEN

105: IF l_Res_rec.completion_transaction_id = FND_API.G_MISS_NUM THEN
106: l_Res_rec.completion_transaction_id := NULL;
107: END IF;
108:
109: IF l_Res_rec.created_by = FND_API.G_MISS_NUM THEN
110: l_Res_rec.created_by := NULL;
111: END IF;
112:
113: IF l_Res_rec.created_by_name = FND_API.G_MISS_CHAR THEN

Line 113: IF l_Res_rec.created_by_name = FND_API.G_MISS_CHAR THEN

109: IF l_Res_rec.created_by = FND_API.G_MISS_NUM THEN
110: l_Res_rec.created_by := NULL;
111: END IF;
112:
113: IF l_Res_rec.created_by_name = FND_API.G_MISS_CHAR THEN
114: l_Res_rec.created_by_name := NULL;
115: END IF;
116:
117: IF l_Res_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 117: IF l_Res_rec.creation_date = FND_API.G_MISS_DATE THEN

113: IF l_Res_rec.created_by_name = FND_API.G_MISS_CHAR THEN
114: l_Res_rec.created_by_name := NULL;
115: END IF;
116:
117: IF l_Res_rec.creation_date = FND_API.G_MISS_DATE THEN
118: l_Res_rec.creation_date := NULL;
119: END IF;
120:
121: IF l_Res_rec.currency_actual_rsc_rate = FND_API.G_MISS_NUM THEN

Line 121: IF l_Res_rec.currency_actual_rsc_rate = FND_API.G_MISS_NUM THEN

117: IF l_Res_rec.creation_date = FND_API.G_MISS_DATE THEN
118: l_Res_rec.creation_date := NULL;
119: END IF;
120:
121: IF l_Res_rec.currency_actual_rsc_rate = FND_API.G_MISS_NUM THEN
122: l_Res_rec.currency_actual_rsc_rate := NULL;
123: END IF;
124:
125: IF l_Res_rec.currency_code = FND_API.G_MISS_CHAR THEN

Line 125: IF l_Res_rec.currency_code = FND_API.G_MISS_CHAR THEN

121: IF l_Res_rec.currency_actual_rsc_rate = FND_API.G_MISS_NUM THEN
122: l_Res_rec.currency_actual_rsc_rate := NULL;
123: END IF;
124:
125: IF l_Res_rec.currency_code = FND_API.G_MISS_CHAR THEN
126: l_Res_rec.currency_code := NULL;
127: END IF;
128:
129: IF l_Res_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN

Line 129: IF l_Res_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN

125: IF l_Res_rec.currency_code = FND_API.G_MISS_CHAR THEN
126: l_Res_rec.currency_code := NULL;
127: END IF;
128:
129: IF l_Res_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
130: l_Res_rec.currency_conversion_date := NULL;
131: END IF;
132:
133: IF l_Res_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN

Line 133: IF l_Res_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN

129: IF l_Res_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
130: l_Res_rec.currency_conversion_date := NULL;
131: END IF;
132:
133: IF l_Res_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
134: l_Res_rec.currency_conversion_rate := NULL;
135: END IF;
136:
137: IF l_Res_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN

Line 137: IF l_Res_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN

133: IF l_Res_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
134: l_Res_rec.currency_conversion_rate := NULL;
135: END IF;
136:
137: IF l_Res_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
138: l_Res_rec.currency_conversion_type := NULL;
139: END IF;
140:
141: IF l_Res_rec.department_code = FND_API.G_MISS_CHAR THEN

Line 141: IF l_Res_rec.department_code = FND_API.G_MISS_CHAR THEN

137: IF l_Res_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
138: l_Res_rec.currency_conversion_type := NULL;
139: END IF;
140:
141: IF l_Res_rec.department_code = FND_API.G_MISS_CHAR THEN
142: l_Res_rec.department_code := NULL;
143: END IF;
144:
145: IF l_Res_rec.department_id = FND_API.G_MISS_NUM THEN

Line 145: IF l_Res_rec.department_id = FND_API.G_MISS_NUM THEN

141: IF l_Res_rec.department_code = FND_API.G_MISS_CHAR THEN
142: l_Res_rec.department_code := NULL;
143: END IF;
144:
145: IF l_Res_rec.department_id = FND_API.G_MISS_NUM THEN
146: l_Res_rec.department_id := NULL;
147: END IF;
148:
149: IF l_Res_rec.employee_id = FND_API.G_MISS_NUM THEN

Line 149: IF l_Res_rec.employee_id = FND_API.G_MISS_NUM THEN

145: IF l_Res_rec.department_id = FND_API.G_MISS_NUM THEN
146: l_Res_rec.department_id := NULL;
147: END IF;
148:
149: IF l_Res_rec.employee_id = FND_API.G_MISS_NUM THEN
150: l_Res_rec.employee_id := NULL;
151: END IF;
152:
153: IF l_Res_rec.employee_num = FND_API.G_MISS_CHAR THEN

Line 153: IF l_Res_rec.employee_num = FND_API.G_MISS_CHAR THEN

149: IF l_Res_rec.employee_id = FND_API.G_MISS_NUM THEN
150: l_Res_rec.employee_id := NULL;
151: END IF;
152:
153: IF l_Res_rec.employee_num = FND_API.G_MISS_CHAR THEN
154: l_Res_rec.employee_num := NULL;
155: END IF;
156:
157: IF l_Res_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 157: IF l_Res_rec.entity_type = FND_API.G_MISS_NUM THEN

153: IF l_Res_rec.employee_num = FND_API.G_MISS_CHAR THEN
154: l_Res_rec.employee_num := NULL;
155: END IF;
156:
157: IF l_Res_rec.entity_type = FND_API.G_MISS_NUM THEN
158: l_Res_rec.entity_type := NULL;
159: END IF;
160:
161: IF l_Res_rec.group_id = FND_API.G_MISS_NUM THEN

Line 161: IF l_Res_rec.group_id = FND_API.G_MISS_NUM THEN

157: IF l_Res_rec.entity_type = FND_API.G_MISS_NUM THEN
158: l_Res_rec.entity_type := NULL;
159: END IF;
160:
161: IF l_Res_rec.group_id = FND_API.G_MISS_NUM THEN
162: l_Res_rec.group_id := NULL;
163: END IF;
164:
165: IF l_Res_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 165: IF l_Res_rec.last_updated_by = FND_API.G_MISS_NUM THEN

161: IF l_Res_rec.group_id = FND_API.G_MISS_NUM THEN
162: l_Res_rec.group_id := NULL;
163: END IF;
164:
165: IF l_Res_rec.last_updated_by = FND_API.G_MISS_NUM THEN
166: l_Res_rec.last_updated_by := NULL;
167: END IF;
168:
169: IF l_Res_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

Line 169: IF l_Res_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

165: IF l_Res_rec.last_updated_by = FND_API.G_MISS_NUM THEN
166: l_Res_rec.last_updated_by := NULL;
167: END IF;
168:
169: IF l_Res_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
170: l_Res_rec.last_updated_by_name := NULL;
171: END IF;
172:
173: IF l_Res_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 173: IF l_Res_rec.last_update_date = FND_API.G_MISS_DATE THEN

169: IF l_Res_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
170: l_Res_rec.last_updated_by_name := NULL;
171: END IF;
172:
173: IF l_Res_rec.last_update_date = FND_API.G_MISS_DATE THEN
174: l_Res_rec.last_update_date := NULL;
175: END IF;
176:
177: IF l_Res_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 177: IF l_Res_rec.last_update_login = FND_API.G_MISS_NUM THEN

173: IF l_Res_rec.last_update_date = FND_API.G_MISS_DATE THEN
174: l_Res_rec.last_update_date := NULL;
175: END IF;
176:
177: IF l_Res_rec.last_update_login = FND_API.G_MISS_NUM THEN
178: l_Res_rec.last_update_login := NULL;
179: END IF;
180:
181: IF l_Res_rec.line_code = FND_API.G_MISS_CHAR THEN

Line 181: IF l_Res_rec.line_code = FND_API.G_MISS_CHAR THEN

177: IF l_Res_rec.last_update_login = FND_API.G_MISS_NUM THEN
178: l_Res_rec.last_update_login := NULL;
179: END IF;
180:
181: IF l_Res_rec.line_code = FND_API.G_MISS_CHAR THEN
182: l_Res_rec.line_code := NULL;
183: END IF;
184:
185: IF l_Res_rec.line_id = FND_API.G_MISS_NUM THEN

Line 185: IF l_Res_rec.line_id = FND_API.G_MISS_NUM THEN

181: IF l_Res_rec.line_code = FND_API.G_MISS_CHAR THEN
182: l_Res_rec.line_code := NULL;
183: END IF;
184:
185: IF l_Res_rec.line_id = FND_API.G_MISS_NUM THEN
186: l_Res_rec.line_id := NULL;
187: END IF;
188:
189: IF l_Res_rec.move_transaction_id = FND_API.G_MISS_NUM THEN

Line 189: IF l_Res_rec.move_transaction_id = FND_API.G_MISS_NUM THEN

185: IF l_Res_rec.line_id = FND_API.G_MISS_NUM THEN
186: l_Res_rec.line_id := NULL;
187: END IF;
188:
189: IF l_Res_rec.move_transaction_id = FND_API.G_MISS_NUM THEN
190: l_Res_rec.move_transaction_id := NULL;
191: END IF;
192:
193: IF l_Res_rec.operation_seq_num = FND_API.G_MISS_NUM THEN

Line 193: IF l_Res_rec.operation_seq_num = FND_API.G_MISS_NUM THEN

189: IF l_Res_rec.move_transaction_id = FND_API.G_MISS_NUM THEN
190: l_Res_rec.move_transaction_id := NULL;
191: END IF;
192:
193: IF l_Res_rec.operation_seq_num = FND_API.G_MISS_NUM THEN
194: l_Res_rec.operation_seq_num := NULL;
195: END IF;
196:
197: IF l_Res_rec.organization_code = FND_API.G_MISS_CHAR THEN

Line 197: IF l_Res_rec.organization_code = FND_API.G_MISS_CHAR THEN

193: IF l_Res_rec.operation_seq_num = FND_API.G_MISS_NUM THEN
194: l_Res_rec.operation_seq_num := NULL;
195: END IF;
196:
197: IF l_Res_rec.organization_code = FND_API.G_MISS_CHAR THEN
198: l_Res_rec.organization_code := NULL;
199: END IF;
200:
201: IF l_Res_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 201: IF l_Res_rec.organization_id = FND_API.G_MISS_NUM THEN

197: IF l_Res_rec.organization_code = FND_API.G_MISS_CHAR THEN
198: l_Res_rec.organization_code := NULL;
199: END IF;
200:
201: IF l_Res_rec.organization_id = FND_API.G_MISS_NUM THEN
202: l_Res_rec.organization_id := NULL;
203: END IF;
204:
205: IF l_Res_rec.po_header_id = FND_API.G_MISS_NUM THEN

Line 205: IF l_Res_rec.po_header_id = FND_API.G_MISS_NUM THEN

201: IF l_Res_rec.organization_id = FND_API.G_MISS_NUM THEN
202: l_Res_rec.organization_id := NULL;
203: END IF;
204:
205: IF l_Res_rec.po_header_id = FND_API.G_MISS_NUM THEN
206: l_Res_rec.po_header_id := NULL;
207: END IF;
208:
209: IF l_Res_rec.po_line_id = FND_API.G_MISS_NUM THEN

Line 209: IF l_Res_rec.po_line_id = FND_API.G_MISS_NUM THEN

205: IF l_Res_rec.po_header_id = FND_API.G_MISS_NUM THEN
206: l_Res_rec.po_header_id := NULL;
207: END IF;
208:
209: IF l_Res_rec.po_line_id = FND_API.G_MISS_NUM THEN
210: l_Res_rec.po_line_id := NULL;
211: END IF;
212:
213: IF l_Res_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 213: IF l_Res_rec.primary_item_id = FND_API.G_MISS_NUM THEN

209: IF l_Res_rec.po_line_id = FND_API.G_MISS_NUM THEN
210: l_Res_rec.po_line_id := NULL;
211: END IF;
212:
213: IF l_Res_rec.primary_item_id = FND_API.G_MISS_NUM THEN
214: l_Res_rec.primary_item_id := NULL;
215: END IF;
216:
217: IF l_Res_rec.primary_quantity = FND_API.G_MISS_NUM THEN

Line 217: IF l_Res_rec.primary_quantity = FND_API.G_MISS_NUM THEN

213: IF l_Res_rec.primary_item_id = FND_API.G_MISS_NUM THEN
214: l_Res_rec.primary_item_id := NULL;
215: END IF;
216:
217: IF l_Res_rec.primary_quantity = FND_API.G_MISS_NUM THEN
218: l_Res_rec.primary_quantity := NULL;
219: END IF;
220:
221: IF l_Res_rec.primary_uom = FND_API.G_MISS_CHAR THEN

Line 221: IF l_Res_rec.primary_uom = FND_API.G_MISS_CHAR THEN

217: IF l_Res_rec.primary_quantity = FND_API.G_MISS_NUM THEN
218: l_Res_rec.primary_quantity := NULL;
219: END IF;
220:
221: IF l_Res_rec.primary_uom = FND_API.G_MISS_CHAR THEN
222: l_Res_rec.primary_uom := NULL;
223: END IF;
224:
225: IF l_Res_rec.primary_uom_class = FND_API.G_MISS_CHAR THEN

Line 225: IF l_Res_rec.primary_uom_class = FND_API.G_MISS_CHAR THEN

221: IF l_Res_rec.primary_uom = FND_API.G_MISS_CHAR THEN
222: l_Res_rec.primary_uom := NULL;
223: END IF;
224:
225: IF l_Res_rec.primary_uom_class = FND_API.G_MISS_CHAR THEN
226: l_Res_rec.primary_uom_class := NULL;
227: END IF;
228:
229: IF l_Res_rec.process_phase = FND_API.G_MISS_NUM THEN

Line 229: IF l_Res_rec.process_phase = FND_API.G_MISS_NUM THEN

225: IF l_Res_rec.primary_uom_class = FND_API.G_MISS_CHAR THEN
226: l_Res_rec.primary_uom_class := NULL;
227: END IF;
228:
229: IF l_Res_rec.process_phase = FND_API.G_MISS_NUM THEN
230: l_Res_rec.process_phase := NULL;
231: END IF;
232:
233: IF l_Res_rec.process_status = FND_API.G_MISS_NUM THEN

Line 233: IF l_Res_rec.process_status = FND_API.G_MISS_NUM THEN

229: IF l_Res_rec.process_phase = FND_API.G_MISS_NUM THEN
230: l_Res_rec.process_phase := NULL;
231: END IF;
232:
233: IF l_Res_rec.process_status = FND_API.G_MISS_NUM THEN
234: l_Res_rec.process_status := NULL;
235: END IF;
236:
237: IF l_Res_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 237: IF l_Res_rec.program_application_id = FND_API.G_MISS_NUM THEN

233: IF l_Res_rec.process_status = FND_API.G_MISS_NUM THEN
234: l_Res_rec.process_status := NULL;
235: END IF;
236:
237: IF l_Res_rec.program_application_id = FND_API.G_MISS_NUM THEN
238: l_Res_rec.program_application_id := NULL;
239: END IF;
240:
241: IF l_Res_rec.program_id = FND_API.G_MISS_NUM THEN

Line 241: IF l_Res_rec.program_id = FND_API.G_MISS_NUM THEN

237: IF l_Res_rec.program_application_id = FND_API.G_MISS_NUM THEN
238: l_Res_rec.program_application_id := NULL;
239: END IF;
240:
241: IF l_Res_rec.program_id = FND_API.G_MISS_NUM THEN
242: l_Res_rec.program_id := NULL;
243: END IF;
244:
245: IF l_Res_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 245: IF l_Res_rec.program_update_date = FND_API.G_MISS_DATE THEN

241: IF l_Res_rec.program_id = FND_API.G_MISS_NUM THEN
242: l_Res_rec.program_id := NULL;
243: END IF;
244:
245: IF l_Res_rec.program_update_date = FND_API.G_MISS_DATE THEN
246: l_Res_rec.program_update_date := NULL;
247: END IF;
248:
249: IF l_Res_rec.project_id = FND_API.G_MISS_NUM THEN

Line 249: IF l_Res_rec.project_id = FND_API.G_MISS_NUM THEN

245: IF l_Res_rec.program_update_date = FND_API.G_MISS_DATE THEN
246: l_Res_rec.program_update_date := NULL;
247: END IF;
248:
249: IF l_Res_rec.project_id = FND_API.G_MISS_NUM THEN
250: l_Res_rec.project_id := NULL;
251: END IF;
252:
253: IF l_Res_rec.rcv_transaction_id = FND_API.G_MISS_NUM THEN

Line 253: IF l_Res_rec.rcv_transaction_id = FND_API.G_MISS_NUM THEN

249: IF l_Res_rec.project_id = FND_API.G_MISS_NUM THEN
250: l_Res_rec.project_id := NULL;
251: END IF;
252:
253: IF l_Res_rec.rcv_transaction_id = FND_API.G_MISS_NUM THEN
254: l_Res_rec.rcv_transaction_id := NULL;
255: END IF;
256:
257: IF l_Res_rec.reason_id = FND_API.G_MISS_NUM THEN

Line 257: IF l_Res_rec.reason_id = FND_API.G_MISS_NUM THEN

253: IF l_Res_rec.rcv_transaction_id = FND_API.G_MISS_NUM THEN
254: l_Res_rec.rcv_transaction_id := NULL;
255: END IF;
256:
257: IF l_Res_rec.reason_id = FND_API.G_MISS_NUM THEN
258: l_Res_rec.reason_id := NULL;
259: END IF;
260:
261: IF l_Res_rec.reason_name = FND_API.G_MISS_CHAR THEN

Line 261: IF l_Res_rec.reason_name = FND_API.G_MISS_CHAR THEN

257: IF l_Res_rec.reason_id = FND_API.G_MISS_NUM THEN
258: l_Res_rec.reason_id := NULL;
259: END IF;
260:
261: IF l_Res_rec.reason_name = FND_API.G_MISS_CHAR THEN
262: l_Res_rec.reason_name := NULL;
263: END IF;
264:
265: IF l_Res_rec.receiving_account_id = FND_API.G_MISS_NUM THEN

Line 265: IF l_Res_rec.receiving_account_id = FND_API.G_MISS_NUM THEN

261: IF l_Res_rec.reason_name = FND_API.G_MISS_CHAR THEN
262: l_Res_rec.reason_name := NULL;
263: END IF;
264:
265: IF l_Res_rec.receiving_account_id = FND_API.G_MISS_NUM THEN
266: l_Res_rec.receiving_account_id := NULL;
267: END IF;
268:
269: IF l_Res_rec.reference = FND_API.G_MISS_CHAR THEN

Line 269: IF l_Res_rec.reference = FND_API.G_MISS_CHAR THEN

265: IF l_Res_rec.receiving_account_id = FND_API.G_MISS_NUM THEN
266: l_Res_rec.receiving_account_id := NULL;
267: END IF;
268:
269: IF l_Res_rec.reference = FND_API.G_MISS_CHAR THEN
270: l_Res_rec.reference := NULL;
271: END IF;
272:
273: IF l_Res_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

Line 273: IF l_Res_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

269: IF l_Res_rec.reference = FND_API.G_MISS_CHAR THEN
270: l_Res_rec.reference := NULL;
271: END IF;
272:
273: IF l_Res_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
274: l_Res_rec.repetitive_schedule_id := NULL;
275: END IF;
276:
277: IF l_Res_rec.request_id = FND_API.G_MISS_NUM THEN

Line 277: IF l_Res_rec.request_id = FND_API.G_MISS_NUM THEN

273: IF l_Res_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
274: l_Res_rec.repetitive_schedule_id := NULL;
275: END IF;
276:
277: IF l_Res_rec.request_id = FND_API.G_MISS_NUM THEN
278: l_Res_rec.request_id := NULL;
279: END IF;
280:
281: IF l_Res_rec.resource_code = FND_API.G_MISS_CHAR THEN

Line 281: IF l_Res_rec.resource_code = FND_API.G_MISS_CHAR THEN

277: IF l_Res_rec.request_id = FND_API.G_MISS_NUM THEN
278: l_Res_rec.request_id := NULL;
279: END IF;
280:
281: IF l_Res_rec.resource_code = FND_API.G_MISS_CHAR THEN
282: l_Res_rec.resource_code := NULL;
283: END IF;
284:
285: IF l_Res_rec.resource_id = FND_API.G_MISS_NUM THEN

Line 285: IF l_Res_rec.resource_id = FND_API.G_MISS_NUM THEN

281: IF l_Res_rec.resource_code = FND_API.G_MISS_CHAR THEN
282: l_Res_rec.resource_code := NULL;
283: END IF;
284:
285: IF l_Res_rec.resource_id = FND_API.G_MISS_NUM THEN
286: l_Res_rec.resource_id := NULL;
287: END IF;
288:
289: IF l_Res_rec.resource_seq_num = FND_API.G_MISS_NUM THEN

Line 289: IF l_Res_rec.resource_seq_num = FND_API.G_MISS_NUM THEN

285: IF l_Res_rec.resource_id = FND_API.G_MISS_NUM THEN
286: l_Res_rec.resource_id := NULL;
287: END IF;
288:
289: IF l_Res_rec.resource_seq_num = FND_API.G_MISS_NUM THEN
290: l_Res_rec.resource_seq_num := NULL;
291: END IF;
292:
293: IF l_Res_rec.resource_type = FND_API.G_MISS_NUM THEN

Line 293: IF l_Res_rec.resource_type = FND_API.G_MISS_NUM THEN

289: IF l_Res_rec.resource_seq_num = FND_API.G_MISS_NUM THEN
290: l_Res_rec.resource_seq_num := NULL;
291: END IF;
292:
293: IF l_Res_rec.resource_type = FND_API.G_MISS_NUM THEN
294: l_Res_rec.resource_type := NULL;
295: END IF;
296:
297: IF l_Res_rec.source_code = FND_API.G_MISS_CHAR THEN

Line 297: IF l_Res_rec.source_code = FND_API.G_MISS_CHAR THEN

293: IF l_Res_rec.resource_type = FND_API.G_MISS_NUM THEN
294: l_Res_rec.resource_type := NULL;
295: END IF;
296:
297: IF l_Res_rec.source_code = FND_API.G_MISS_CHAR THEN
298: l_Res_rec.source_code := NULL;
299: END IF;
300:
301: IF l_Res_rec.source_line_id = FND_API.G_MISS_NUM THEN

Line 301: IF l_Res_rec.source_line_id = FND_API.G_MISS_NUM THEN

297: IF l_Res_rec.source_code = FND_API.G_MISS_CHAR THEN
298: l_Res_rec.source_code := NULL;
299: END IF;
300:
301: IF l_Res_rec.source_line_id = FND_API.G_MISS_NUM THEN
302: l_Res_rec.source_line_id := NULL;
303: END IF;
304:
305: IF l_Res_rec.standard_rate_flag = FND_API.G_MISS_NUM THEN

Line 305: IF l_Res_rec.standard_rate_flag = FND_API.G_MISS_NUM THEN

301: IF l_Res_rec.source_line_id = FND_API.G_MISS_NUM THEN
302: l_Res_rec.source_line_id := NULL;
303: END IF;
304:
305: IF l_Res_rec.standard_rate_flag = FND_API.G_MISS_NUM THEN
306: l_Res_rec.standard_rate_flag := NULL;
307: END IF;
308:
309: IF l_Res_rec.task_id = FND_API.G_MISS_NUM THEN

Line 309: IF l_Res_rec.task_id = FND_API.G_MISS_NUM THEN

305: IF l_Res_rec.standard_rate_flag = FND_API.G_MISS_NUM THEN
306: l_Res_rec.standard_rate_flag := NULL;
307: END IF;
308:
309: IF l_Res_rec.task_id = FND_API.G_MISS_NUM THEN
310: l_Res_rec.task_id := NULL;
311: END IF;
312:
313: IF l_Res_rec.transaction_date = FND_API.G_MISS_DATE THEN

Line 313: IF l_Res_rec.transaction_date = FND_API.G_MISS_DATE THEN

309: IF l_Res_rec.task_id = FND_API.G_MISS_NUM THEN
310: l_Res_rec.task_id := NULL;
311: END IF;
312:
313: IF l_Res_rec.transaction_date = FND_API.G_MISS_DATE THEN
314: l_Res_rec.transaction_date := NULL;
315: END IF;
316:
317: IF l_Res_rec.transaction_id = FND_API.G_MISS_NUM THEN

Line 317: IF l_Res_rec.transaction_id = FND_API.G_MISS_NUM THEN

313: IF l_Res_rec.transaction_date = FND_API.G_MISS_DATE THEN
314: l_Res_rec.transaction_date := NULL;
315: END IF;
316:
317: IF l_Res_rec.transaction_id = FND_API.G_MISS_NUM THEN
318: l_Res_rec.transaction_id := NULL;
319: END IF;
320:
321: IF l_Res_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

Line 321: IF l_Res_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

317: IF l_Res_rec.transaction_id = FND_API.G_MISS_NUM THEN
318: l_Res_rec.transaction_id := NULL;
319: END IF;
320:
321: IF l_Res_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
322: l_Res_rec.transaction_quantity := NULL;
323: END IF;
324:
325: IF l_Res_rec.transaction_type = FND_API.G_MISS_NUM THEN

Line 325: IF l_Res_rec.transaction_type = FND_API.G_MISS_NUM THEN

321: IF l_Res_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
322: l_Res_rec.transaction_quantity := NULL;
323: END IF;
324:
325: IF l_Res_rec.transaction_type = FND_API.G_MISS_NUM THEN
326: l_Res_rec.transaction_type := NULL;
327: END IF;
328:
329: IF l_Res_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

Line 329: IF l_Res_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

325: IF l_Res_rec.transaction_type = FND_API.G_MISS_NUM THEN
326: l_Res_rec.transaction_type := NULL;
327: END IF;
328:
329: IF l_Res_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
330: l_Res_rec.transaction_uom := NULL;
331: END IF;
332:
333: IF l_Res_rec.usage_rate_or_amount = FND_API.G_MISS_NUM THEN

Line 333: IF l_Res_rec.usage_rate_or_amount = FND_API.G_MISS_NUM THEN

329: IF l_Res_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
330: l_Res_rec.transaction_uom := NULL;
331: END IF;
332:
333: IF l_Res_rec.usage_rate_or_amount = FND_API.G_MISS_NUM THEN
334: l_Res_rec.usage_rate_or_amount := NULL;
335: END IF;
336:
337: IF l_Res_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 337: IF l_Res_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

333: IF l_Res_rec.usage_rate_or_amount = FND_API.G_MISS_NUM THEN
334: l_Res_rec.usage_rate_or_amount := NULL;
335: END IF;
336:
337: IF l_Res_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
338: l_Res_rec.wip_entity_id := NULL;
339: END IF;
340:
341: IF l_Res_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 341: IF l_Res_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

337: IF l_Res_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
338: l_Res_rec.wip_entity_id := NULL;
339: END IF;
340:
341: IF l_Res_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
342: l_Res_rec.wip_entity_name := NULL;
343: END IF;
344:
345: /*Fix bug 9356683*/

Line 346: IF l_Res_rec.encumbrance_type_id = FND_API.G_MISS_NUM THEN

342: l_Res_rec.wip_entity_name := NULL;
343: END IF;
344:
345: /*Fix bug 9356683*/
346: IF l_Res_rec.encumbrance_type_id = FND_API.G_MISS_NUM THEN
347: l_Res_rec.encumbrance_type_id := NULL;
348: END IF;
349:
350: IF l_Res_rec.encumbrance_amount = FND_API.G_MISS_NUM THEN

Line 350: IF l_Res_rec.encumbrance_amount = FND_API.G_MISS_NUM THEN

346: IF l_Res_rec.encumbrance_type_id = FND_API.G_MISS_NUM THEN
347: l_Res_rec.encumbrance_type_id := NULL;
348: END IF;
349:
350: IF l_Res_rec.encumbrance_amount = FND_API.G_MISS_NUM THEN
351: l_Res_rec.encumbrance_amount := NULL;
352: END IF;
353:
354: IF l_Res_rec.encumbrance_quantity = FND_API.G_MISS_NUM THEN

Line 354: IF l_Res_rec.encumbrance_quantity = FND_API.G_MISS_NUM THEN

350: IF l_Res_rec.encumbrance_amount = FND_API.G_MISS_NUM THEN
351: l_Res_rec.encumbrance_amount := NULL;
352: END IF;
353:
354: IF l_Res_rec.encumbrance_quantity = FND_API.G_MISS_NUM THEN
355: l_Res_rec.encumbrance_quantity := NULL;
356: END IF;
357:
358: IF l_Res_rec.encumbrance_ccid = FND_API.G_MISS_NUM THEN

Line 358: IF l_Res_rec.encumbrance_ccid = FND_API.G_MISS_NUM THEN

354: IF l_Res_rec.encumbrance_quantity = FND_API.G_MISS_NUM THEN
355: l_Res_rec.encumbrance_quantity := NULL;
356: END IF;
357:
358: IF l_Res_rec.encumbrance_ccid = FND_API.G_MISS_NUM THEN
359: l_Res_rec.encumbrance_ccid := NULL;
360: END IF;
361: /*End of Fix Bug 9356683*/
362:

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: , 'Update_Row'
472: );
473: END IF;
474:
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476:
477: END Update_Row;
478:
479: -- Procedure Insert_Row

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678: , 'Insert_Row'
679: );
680: END IF;
681:
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683:
684: END Insert_Row;
685:
686: -- Procedure Delete_Row

Line 710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

706: , 'Delete_Row'
707: );
708: END IF;
709:
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711:
712: END Delete_Row;
713:
714: -- Function Query_Row

Line 826: WHERE ( PO_HEADER_ID = nvl(p_po_header_id,FND_API.G_MISS_NUM)

822: , USAGE_RATE_OR_AMOUNT
823: , WIP_ENTITY_ID
824: , WIP_ENTITY_NAME
825: FROM WIP_COST_TXN_INTERFACE
826: WHERE ( PO_HEADER_ID = nvl(p_po_header_id,FND_API.G_MISS_NUM)
827: );
828:
829: BEGIN
830:

Line 929: p_po_header_id <> FND_API.G_MISS_NUM)

925:
926: IF
927: (p_po_header_id IS NOT NULL
928: AND
929: p_po_header_id <> FND_API.G_MISS_NUM)
930: AND
931: (l_Res_tbl.COUNT = 0)
932: THEN
933: RAISE NO_DATA_FOUND;

Line 942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

938: RETURN l_Res_tbl;
939:
940: EXCEPTION
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943:
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945:
946: WHEN OTHERS THEN

Line 944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

940: EXCEPTION
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943:
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945:
946: WHEN OTHERS THEN
947:
948: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: , 'Query_Rows'
953: );
954: END IF;
955:
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957:
958: END Query_Rows;
959:
960: -- Procedure lock_Row

Line 1314: x_return_status := FND_API.G_RET_STS_SUCCESS;

1310: x_Res_rec := l_Res_rec;
1311:
1312: -- Set return status
1313:
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315: x_Res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1316:
1317: ELSE
1318:

Line 1315: x_Res_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1311:
1312: -- Set return status
1313:
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315: x_Res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1316:
1317: ELSE
1318:
1319: -- Row has changed by another user.

Line 1321: x_return_status := FND_API.G_RET_STS_ERROR;

1317: ELSE
1318:
1319: -- Row has changed by another user.
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN

Line 1322: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;

1318:
1319: -- Row has changed by another user.
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326:

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: EXCEPTION
1334:
1335: WHEN NO_DATA_FOUND THEN
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1341: THEN

Line 1338: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;

1334:
1335: WHEN NO_DATA_FOUND THEN
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1341: THEN
1342:

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR;

1345:
1346: END IF;
1347: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1348:
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1353: THEN

Line 1350: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;

1346: END IF;
1347: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1348:
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1353: THEN
1354:

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1357:
1358: END IF;
1359: WHEN OTHERS THEN
1360:
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: x_Res_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN

Line 1362: x_Res_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1358: END IF;
1359: WHEN OTHERS THEN
1360:
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: x_Res_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg