DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on FND_LOOKUPS

Line 39: FROM fnd_lookups

35: WHERE transaction_header_id = p_transaction_header_id
36: AND update_purchasing_docs IN ('Y','P') ;
37: SELECT meaning
38: INTO l_process_code
39: FROM fnd_lookups
40: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
41: AND lookup_code ='UPDTPO';
42: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
43: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 58: FROM fnd_lookups

54: WHERE transaction_header_id = p_transaction_header_id
55: AND notify_purchasing_docs IN ('Y','P') ;
56: SELECT meaning
57: INTO l_process_code
58: FROM fnd_lookups
59: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
60: AND lookup_code ='NTFYPO';
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 77: FROM fnd_lookups

73: WHERE transaction_header_id = p_transaction_header_id
74: AND update_inventory_costing IN ('Y','P') ;
75: SELECT meaning
76: INTO l_process_code
77: FROM fnd_lookups
78: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
79: AND lookup_code ='INVC';
80: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
81: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 97: FROM fnd_lookups

93: WHERE transaction_header_id = p_transaction_header_id
94: AND update_item_list_price IN ('Y','P') ;
95: SELECT meaning
96: INTO l_process_code
97: FROM fnd_lookups
98: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
99: AND lookup_code ='UPDTLP';
100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
101: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 116: FROM fnd_lookups

112: WHERE transaction_header_id = p_transaction_header_id
113: AND notify_inbound_pricelist IN ('Y','P') ;
114: SELECT meaning
115: INTO l_process_code
116: FROM fnd_lookups
117: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
118: AND lookup_code ='INPL';
119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
120: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 135: FROM fnd_lookups

131: WHERE transaction_header_id = p_transaction_header_id
132: AND notify_outbound_pricelist IN ('Y','P') ;
133: SELECT meaning
134: INTO l_process_code
135: FROM fnd_lookups
136: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
137: AND lookup_code ='OUTPL';
138: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 154: FROM fnd_lookups

150: WHERE transaction_header_id = p_transaction_header_id
151: AND notify_promotions_pricelist IN ('Y','P') ;
152: SELECT meaning
153: INTO l_process_code
154: FROM fnd_lookups
155: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
156: AND lookup_code ='PROMO';
157: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
158: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 172: FROM fnd_lookups

168: WHERE transaction_header_id = p_transaction_header_id
169: AND supp_dist_claim_status IN ('Y','P') ;
170: SELECT meaning
171: INTO l_process_code
172: FROM fnd_lookups
173: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
174: AND lookup_code ='DSTRINVCL';
175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
176: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 191: FROM fnd_lookups

187: WHERE transaction_header_id = p_transaction_header_id
188: AND supp_dist_claim_status IN ('Y','P') ;
189: SELECT meaning
190: INTO l_process_code
191: FROM fnd_lookups
192: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
193: AND lookup_code ='CUSTCL';
194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
195: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

Line 219: FROM fnd_lookups

215: WHERE transaction_header_id = p_transaction_header_id
216: AND update_purchasing_docs IN ('N','P') ;
217: SELECT meaning
218: INTO l_process_code
219: FROM fnd_lookups
220: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
221: AND lookup_code ='UPDTPO';
222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
223: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 237: FROM fnd_lookups

233: WHERE transaction_header_id = p_transaction_header_id
234: AND notify_purchasing_docs IN ('N','P') ;
235: SELECT meaning
236: INTO l_process_code
237: FROM fnd_lookups
238: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
239: AND lookup_code ='NTFYPO';
240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
241: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 257: FROM fnd_lookups

253: WHERE transaction_header_id = p_transaction_header_id
254: AND update_inventory_costing IN ('N','P') ;
255: SELECT meaning
256: INTO l_process_code
257: FROM fnd_lookups
258: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
259: AND lookup_code ='INVC';
260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
261: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 276: FROM fnd_lookups

272: WHERE transaction_header_id = p_transaction_header_id
273: AND update_item_list_price IN ('N','P') ;
274: SELECT meaning
275: INTO l_process_code
276: FROM fnd_lookups
277: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
278: AND lookup_code ='UPDTLP';
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
280: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 295: FROM fnd_lookups

291: WHERE transaction_header_id = p_transaction_header_id
292: AND notify_inbound_pricelist IN ('N','P') ;
293: SELECT meaning
294: INTO l_process_code
295: FROM fnd_lookups
296: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
297: AND lookup_code ='INPL';
298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
299: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 314: FROM fnd_lookups

310: WHERE transaction_header_id = p_transaction_header_id
311: AND notify_outbound_pricelist IN ('N','P') ;
312: SELECT meaning
313: INTO l_process_code
314: FROM fnd_lookups
315: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
316: AND lookup_code ='OUTPL';
317: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
318: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 333: FROM fnd_lookups

329: WHERE transaction_header_id = p_transaction_header_id
330: AND notify_promotions_pricelist IN ('N','P') ;
331: SELECT meaning
332: INTO l_process_code
333: FROM fnd_lookups
334: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
335: AND lookup_code ='PROMO';
336: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
337: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

Line 352: FROM fnd_lookups

348: WHERE transaction_header_id = p_transaction_header_id
349: AND supp_dist_claim_status IN ('N','P','D') ;
350: SELECT meaning
351: INTO l_process_code
352: FROM fnd_lookups
353: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
354: AND lookup_code ='DSTRINVCL';
355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
356: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');