[Home] [Help]
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: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
43: fnd_message.set_token('PROCESS_CODE', l_process_code);
44: fnd_msg_pub.add;
54: AND update_inventory_costing IN ('Y','P') ;
55: SELECT meaning
56: INTO l_process_code
57: FROM fnd_lookups
58: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
59: AND lookup_code ='INVC';
60: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
61: fnd_message.set_token('PROCESS_CODE', l_process_code);
62: fnd_msg_pub.add;
72: AND update_item_list_price IN ('Y','P') ;
73: SELECT meaning
74: INTO l_process_code
75: FROM fnd_lookups
76: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
77: AND lookup_code ='UPDTLP';
78: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
79: fnd_message.set_token('PROCESS_CODE', l_process_code);
80: fnd_msg_pub.add;
89: AND supp_dist_claim_status IN ('Y','P') ;
90: SELECT meaning
91: INTO l_process_code
92: FROM fnd_lookups
93: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
94: AND lookup_code ='DSTRINVCL';
95: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
96: fnd_message.set_token('PROCESS_CODE', l_process_code);
97: fnd_msg_pub.add;
106: AND supplier_claim_created IN ('Y','P') ;
107: SELECT meaning
108: INTO l_process_code
109: FROM fnd_lookups
110: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
111: AND lookup_code ='CUSTINVCL';
112: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
113: fnd_message.set_token('PROCESS_CODE', l_process_code);
114: fnd_msg_pub.add;
125: ELSIF p_status_change = 'CLOSED' THEN
126:
127: BEGIN
128: SELECT DISTINCT 'Y' INTO l_flag
129: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
130: WHERE dep.transaction_header_id = dtla.transaction_header_id
131: AND dtla.transaction_header_id = p_transaction_header_id
132: AND dep.process_code = 'UPDTPO'
133: AND update_purchasing_docs IN ('N','P');
133: AND update_purchasing_docs IN ('N','P');
134: SELECT meaning
135: INTO l_process_code
136: FROM fnd_lookups
137: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
138: AND lookup_code ='UPDTPO';
139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
140: fnd_message.set_token('PROCESS_CODE', l_process_code);
141: fnd_msg_pub.add;
148:
149:
150: BEGIN
151: SELECT DISTINCT 'Y' INTO l_flag
152: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
153: WHERE dep.transaction_header_id = dtla.transaction_header_id
154: AND dtla.transaction_header_id = p_transaction_header_id
155: AND dep.process_code = 'NTFYPO'
156: AND notify_purchasing_docs IN ('N','P') ;
156: AND notify_purchasing_docs IN ('N','P') ;
157: SELECT meaning
158: INTO l_process_code
159: FROM fnd_lookups
160: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
161: AND lookup_code ='NTFYPO';
162: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
163: fnd_message.set_token('PROCESS_CODE', l_process_code);
164: fnd_msg_pub.add;
171:
172:
173: BEGIN
174: SELECT DISTINCT 'Y' INTO l_flag
175: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
176: WHERE dep.transaction_header_id = dtla.transaction_header_id
177: AND dtla.transaction_header_id = p_transaction_header_id
178: AND dep.process_code = 'INVC'
179: AND update_inventory_costing IN ('N','P') ;
179: AND update_inventory_costing IN ('N','P') ;
180: SELECT meaning
181: INTO l_process_code
182: FROM fnd_lookups
183: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
184: AND lookup_code ='INVC';
185: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
186: fnd_message.set_token('PROCESS_CODE', l_process_code);
187: fnd_msg_pub.add;
193: END;
194:
195: BEGIN
196: SELECT DISTINCT 'Y' INTO l_flag
197: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
198: WHERE dep.transaction_header_id = dtla.transaction_header_id
199: AND dtla.transaction_header_id = p_transaction_header_id
200: AND dep.process_code = 'UPDTLP'
201: AND update_item_list_price IN ('N','P') ;
201: AND update_item_list_price IN ('N','P') ;
202: SELECT meaning
203: INTO l_process_code
204: FROM fnd_lookups
205: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
206: AND lookup_code ='UPDTLP';
207: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
208: fnd_message.set_token('PROCESS_CODE', l_process_code);
209: fnd_msg_pub.add;
215: END;
216:
217: BEGIN
218: SELECT DISTINCT 'Y' INTO l_flag
219: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
220: WHERE dep.transaction_header_id = dtla.transaction_header_id
221: AND dtla.transaction_header_id = p_transaction_header_id
222: AND dep.process_code = 'INPL'
223: AND notify_inbound_pricelist IN ('N','P') ;
223: AND notify_inbound_pricelist IN ('N','P') ;
224: SELECT meaning
225: INTO l_process_code
226: FROM fnd_lookups
227: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
228: AND lookup_code ='INPL';
229: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
230: fnd_message.set_token('PROCESS_CODE', l_process_code);
231: fnd_msg_pub.add;
237: END;
238:
239: BEGIN
240: SELECT DISTINCT 'Y' INTO l_flag
241: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
242: WHERE dep.transaction_header_id = dtla.transaction_header_id
243: AND dtla.transaction_header_id = p_transaction_header_id
244: AND dep.process_code = 'OUTPL'
245: AND notify_outbound_pricelist IN ('N','P') ;
245: AND notify_outbound_pricelist IN ('N','P') ;
246: SELECT meaning
247: INTO l_process_code
248: FROM fnd_lookups
249: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
250: AND lookup_code ='OUTPL';
251: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
252: fnd_message.set_token('PROCESS_CODE', l_process_code);
253: fnd_msg_pub.add;
259: END;
260:
261: BEGIN
262: SELECT DISTINCT 'Y' INTO l_flag
263: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
264: WHERE dep.transaction_header_id = dtla.transaction_header_id
265: AND dtla.transaction_header_id = p_transaction_header_id
266: AND dep.process_code = 'PROMO'
267: AND notify_promotions_pricelist IN ('N','P') ;
267: AND notify_promotions_pricelist IN ('N','P') ;
268: SELECT meaning
269: INTO l_process_code
270: FROM fnd_lookups
271: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
272: AND lookup_code ='PROMO';
273: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
274: fnd_message.set_token('PROCESS_CODE', l_process_code);
275: fnd_msg_pub.add;
281: END;
282:
283: BEGIN
284: SELECT DISTINCT 'Y' INTO l_flag
285: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
286: WHERE dep.transaction_header_id = dtla.transaction_header_id
287: AND dtla.transaction_header_id = p_transaction_header_id
288: AND dep.process_code = 'DSTRINVCL'
289: AND supp_dist_claim_status IN ('N','P','D') ;
289: AND supp_dist_claim_status IN ('N','P','D') ;
290: SELECT meaning
291: INTO l_process_code
292: FROM fnd_lookups
293: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
294: AND lookup_code ='DSTRINVCL';
295: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
296: fnd_message.set_token('PROCESS_CODE', l_process_code);
297: fnd_msg_pub.add;
303: END;
304:
305: BEGIN
306: SELECT DISTINCT 'Y' INTO l_flag
307: FROM dpp_execution_processes dep, dpp_customer_claims_all dcca
308: WHERE dep.transaction_header_id = dcca.transaction_header_id
309: AND dcca.transaction_header_id = p_transaction_header_id
310: AND dep.process_code = 'CUSTINVCL'
311: AND supplier_claim_created IN ('N','P') ;
311: AND supplier_claim_created 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 ='CUSTINVCL';
317: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
318: fnd_message.set_token('PROCESS_CODE', l_process_code);
319: fnd_msg_pub.add;