DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on FND_MESSAGE

Line 195: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');

191: FETCH for_party_name INTO l_requested_by_party_id;
192: IF for_party_name%FOUND THEN
193: p_x_subscription_tbl(i).requested_by_party_id := l_requested_by_party_id;
194: ELSE
195: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
196: FND_MSG_PUB.ADD;
197: END IF;
198: CLOSE for_party_name;
199:

Line 210: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');

206: EXIT WHEN get_party_name%NOTFOUND;
207: END LOOP;
208: -- If no records for name, then name is INVALID: show error
209: IF get_party_name%ROWCOUNT = 0 THEN
210: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');
211: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);
212:
213:
214: FND_MSG_PUB.ADD;

Line 211: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);

207: END LOOP;
208: -- If no records for name, then name is INVALID: show error
209: IF get_party_name%ROWCOUNT = 0 THEN
210: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');
211: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);
212:
213:
214: FND_MSG_PUB.ADD;
215: -- If only 1 record for name, use the id: id will be unique: use id

Line 223: -- FND_MESSAGE.SET_NAME('AHL','LOV dup val');

219: ELSIF
220: --p_x_subscription_tbl(i).requested_by_party_id IS NULL AND
221: p_x_subscription_tbl(i).requested_by_party_id IS NULL
222: THEN
223: -- FND_MESSAGE.SET_NAME('AHL','LOV dup val');
224: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');
225: FND_MSG_PUB.ADD;
226: END IF;
227: CLOSE get_party_name;

Line 224: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');

220: --p_x_subscription_tbl(i).requested_by_party_id IS NULL AND
221: p_x_subscription_tbl(i).requested_by_party_id IS NULL
222: THEN
223: -- FND_MESSAGE.SET_NAME('AHL','LOV dup val');
224: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');
225: FND_MSG_PUB.ADD;
226: END IF;
227: CLOSE get_party_name;
228: END IF;

Line 232: -- FND_MESSAGE.SET_NAME('AHL',' '|| p_x_subscription_tbl(i).requested_by_pty_name);

228: END IF;
229:
230: -- Party Name is not present: since id is mandatory: show error
231: ELSE
232: -- FND_MESSAGE.SET_NAME('AHL',' '|| p_x_subscription_tbl(i).requested_by_pty_name);
233: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');
234: FND_MSG_PUB.ADD;
235:
236: END IF;

Line 233: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');

229:
230: -- Party Name is not present: since id is mandatory: show error
231: ELSE
232: -- FND_MESSAGE.SET_NAME('AHL',' '|| p_x_subscription_tbl(i).requested_by_pty_name);
233: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');
234: FND_MSG_PUB.ADD;
235:
236: END IF;
237:

Line 250: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');

246: IF for_party_name%FOUND
247: THEN
248: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
249: ELSE
250: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
251: FND_MSG_PUB.ADD;
252: END IF;
253: CLOSE for_party_name;
254:

Line 262: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');

258: IF for_vendor_id%FOUND
259: THEN
260: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
261: ELSE
262: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
264: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
265: FND_MSG_PUB.ADD;
266: END IF;

Line 263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');

259: THEN
260: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
261: ELSE
262: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
264: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
265: FND_MSG_PUB.ADD;
266: END IF;
267: CLOSE for_vendor_id;

Line 264: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);

260: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
261: ELSE
262: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
263: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
264: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
265: FND_MSG_PUB.ADD;
266: END IF;
267: CLOSE for_vendor_id;
268:

Line 275: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');

271: -- Enhancement #2034767 : Party Name is mandatory. Throw error message : pbarman Arpil 2003
272: ELSE
273:
274: -- l_subscription_tbl(i).subscribed_frm_party_id := null;
275: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');
276: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);
277: FND_MSG_PUB.ADD;
278: END IF;
279:

Line 276: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);

272: ELSE
273:
274: -- l_subscription_tbl(i).subscribed_frm_party_id := null;
275: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');
276: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);
277: FND_MSG_PUB.ADD;
278: END IF;
279:
280: --For Media Type Code

Line 294: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');

290: x_return_status => l_return_status);
291:
292: IF nvl(l_return_status, 'X') <> 'S'
293: THEN
294: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
295: FND_MSG_PUB.ADD;
296: END IF;
297: END IF;
298: -- If id is present

Line 315: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');

311: x_return_status => l_return_status);
312:
313: IF nvl(l_return_status, 'X') <> 'S'
314: THEN
315: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');
316: FND_MSG_PUB.ADD;
317: END IF;
318: END IF;
319: -- Code Presents

Line 336: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');

332: x_return_status => l_return_status);
333:
334: IF nvl(l_return_status, 'X') <> 'S'
335: THEN
336: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');
337: FND_MSG_PUB.ADD;
338: END IF;
339: END IF;
340: -- Frequency Code present

Line 357: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');

353: x_return_status => l_return_status);
354:
355: IF nvl(l_return_status, 'X') <> 'S'
356: THEN
357: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');
358: FND_MSG_PUB.ADD;
359: END IF;
360: END IF;
361: -- If Status Code is Avialable

Line 366: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NULL');

362: IF p_x_subscription_tbl(i).status_code IS NOT NULL
363: THEN
364: l_subscription_tbl(i).status_code := p_x_subscription_tbl(i).status_code;
365: ELSE
366: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NULL');
367: FND_MSG_PUB.ADD;
368: END IF;
369:
370:

Line 378: FND_MESSAGE.SET_NAME('AHL','AHL_DI_QTY_NON_INT');

374: THEN
375: l_check_quantity := p_x_subscription_tbl(i).quantity;
376: IF l_check_quantity > TRUNC(l_check_quantity,0)
377: THEN
378: FND_MESSAGE.SET_NAME('AHL','AHL_DI_QTY_NON_INT');
379: FND_MSG_PUB.ADD;
380: END IF;
381: END IF;
382: -- Enhancement #2525108: check PO Number against PO Numbers in PO_PURCHASE_ORDER_V: pbarman april 2003

Line 393: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PO_NUM_NOT_EXISTS');

389: FETCH for_ponumber_id INTO l_purchase_order_no;
390: IF for_ponumber_id%FOUND THEN
391: l_subscription_tbl(i).purchase_order_no := l_purchase_order_no;
392: ELSE
393: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PO_NUM_NOT_EXISTS');
394: FND_MSG_PUB.ADD;
395: END IF;
396: CLOSE for_ponumber_id;
397:

Line 845: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');

841: FETCH for_party_name INTO l_requested_by_party_id;
842: IF for_party_name%FOUND THEN
843: l_subscription_tbl(i).requested_by_party_id := l_requested_by_party_id;
844: ELSE
845: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
846: FND_MSG_PUB.ADD;
847: END IF;
848: CLOSE for_party_name;
849:

Line 867: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');

863: END LOOP;
864: -- If no records for name, then name is INVALID: show error
865: IF get_party_name%ROWCOUNT = 0 THEN
866:
867: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
868: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');
869: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);
870: FND_MSG_PUB.ADD;
871:

Line 868: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');

864: -- If no records for name, then name is INVALID: show error
865: IF get_party_name%ROWCOUNT = 0 THEN
866:
867: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
868: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');
869: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);
870: FND_MSG_PUB.ADD;
871:
872:

Line 869: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);

865: IF get_party_name%ROWCOUNT = 0 THEN
866:
867: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NOT_EXISTS');
868: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_ID_NOT_EXISTS');
869: FND_MESSAGE.SET_TOKEN('REQ',p_x_subscription_tbl(i).requested_by_pty_name);
870: FND_MSG_PUB.ADD;
871:
872:
873: -- If only 1 record for name, use the id: id will be unique: use id

Line 879: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_edit');

875: p_x_subscription_tbl(i).requested_by_party_id := l_requested_by_party_id;
876: -- If more than 1 record, then error: id is not unique: ask user to choose from LOV
877: ELSIF p_x_subscription_tbl(i).requested_by_party_id IS NULL
878: THEN
879: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_edit');
880: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');
881: FND_MSG_PUB.ADD;
882: END IF;
883: CLOSE get_party_name;

Line 880: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');

876: -- If more than 1 record, then error: id is not unique: ask user to choose from LOV
877: ELSIF p_x_subscription_tbl(i).requested_by_party_id IS NULL
878: THEN
879: -- FND_MESSAGE.SET_NAME('AHL','AHL_DI_edit');
880: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQUESTED_BY_USE_LOV');
881: FND_MSG_PUB.ADD;
882: END IF;
883: CLOSE get_party_name;
884: END IF;

Line 893: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');

889: -- Party Name is not present: since id is mandatory: show error
890: ELSE
891: IF p_x_subscription_tbl(i).delete_flag = 'N'
892: THEN
893: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REQ_PTY_ID_NULL');
894: FND_MSG_PUB.ADD;
895: END IF;
896: END IF;
897:

Line 910: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');

906: IF for_party_name%FOUND
907: THEN
908: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
909: ELSE
910: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
911: FND_MSG_PUB.ADD;
912: END IF;
913: CLOSE for_party_name;
914:

Line 922: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');

918: IF for_vendor_id%FOUND
919: THEN
920: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
921: ELSE
922: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
923: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
924: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
925:
926:

Line 923: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');

919: THEN
920: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
921: ELSE
922: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
923: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
924: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
925:
926:
927: FND_MSG_PUB.ADD;

Line 924: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);

920: l_subscription_tbl(i).subscribed_frm_party_id := l_supplier_id;
921: ELSE
922: --FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_PTY_ID_INVALID');
923: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUB_ID_INVALID');
924: FND_MESSAGE.SET_TOKEN('SUP',p_x_subscription_tbl(i).subscribed_frm_pty_name);
925:
926:
927: FND_MSG_PUB.ADD;
928: END IF;

Line 938: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');

934: ELSE
935: --l_subscription_tbl(i).subscribed_frm_party_id := null;
936: IF p_x_subscription_tbl(i).delete_flag = 'N'
937: THEN
938: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');
939: IF p_x_subscription_tbl(i).requested_by_pty_name IS NOT NULL THEN
940: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);
941: ELSE
942: FND_MESSAGE.SET_TOKEN('FIELD1', '');

Line 940: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);

936: IF p_x_subscription_tbl(i).delete_flag = 'N'
937: THEN
938: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');
939: IF p_x_subscription_tbl(i).requested_by_pty_name IS NOT NULL THEN
940: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);
941: ELSE
942: FND_MESSAGE.SET_TOKEN('FIELD1', '');
943: END IF;
944:

Line 942: FND_MESSAGE.SET_TOKEN('FIELD1', '');

938: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBSCRIPTION_REQD');
939: IF p_x_subscription_tbl(i).requested_by_pty_name IS NOT NULL THEN
940: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_subscription_tbl(i).requested_by_pty_name);
941: ELSE
942: FND_MESSAGE.SET_TOKEN('FIELD1', '');
943: END IF;
944:
945: FND_MSG_PUB.ADD;
946: END IF;

Line 963: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');

959: x_return_status => l_return_status);
960:
961: IF nvl(l_return_status, 'X') <> 'S'
962: THEN
963: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_CODE_NOT_EXISTS');
964: FND_MSG_PUB.ADD;
965: END IF;
966: END IF;
967: -- If id is present

Line 983: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');

979: x_return_status => l_return_status);
980:
981: IF nvl(l_return_status, 'X') <> 'S'
982: THEN
983: FND_MESSAGE.SET_NAME('AHL','AHL_DI_SUBTYP_CODE_NOT_EXISTS');
984: FND_MSG_PUB.ADD;
985: END IF;
986: END IF;
987: -- Subscription type code is available

Line 1004: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');

1000: x_return_status => l_return_status);
1001:
1002: IF nvl(l_return_status, 'X') <> 'S'
1003: THEN
1004: FND_MESSAGE.SET_NAME('AHL','AHL_DI_FREQCY_CODE_NOT_EXISTS');
1005: FND_MSG_PUB.ADD;
1006: END IF;
1007: END IF;
1008: -- Frequency Code present

Line 1025: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');

1021: x_return_status => l_return_status);
1022:
1023: IF nvl(l_return_status, 'X') <> 'S'
1024: THEN
1025: FND_MESSAGE.SET_NAME('AHL','AHL_DI_STATUS_CODE_NOT_EXISTS');
1026: FND_MSG_PUB.ADD;
1027: END IF;
1028: END IF;
1029: -- If Status Code is Avialable

Line 1039: FND_MESSAGE.SET_NAME('AHL','AHL_DI_QTY_NON_INT');

1035: THEN
1036: l_check_quantity := p_x_subscription_tbl(i).quantity;
1037: IF l_check_quantity > TRUNC(l_check_quantity,0)
1038: THEN
1039: FND_MESSAGE.SET_NAME('AHL','AHL_DI_QTY_NON_INT');
1040: FND_MSG_PUB.ADD;
1041: END IF;
1042: END IF;
1043:

Line 1060: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PO_NUM_NOT_EXISTS');

1056:
1057: ELSE
1058: IF p_x_subscription_tbl(i).delete_flag = 'N'
1059: THEN
1060: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PO_NUM_NOT_EXISTS');
1061: FND_MSG_PUB.ADD;
1062: END IF;
1063: END IF;
1064: CLOSE for_ponumber_id;