DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT2 dependencies on ICX_UTIL

Line 71: icx_util.add_error(v_error_message);

67: v_error_message := FND_MESSAGE.GET;
68: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
69: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
70:
71: icx_util.add_error(v_error_message);
72: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number);
73:
74: elsif v_account_id is not NULL then
75: l_account_id := v_account_id;

Line 87: icx_util.add_error(v_error_message);

83: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
84: v_error_message := FND_MESSAGE.GET;
85: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
86: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
87: icx_util.add_error(v_error_message);
88: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
89: end if;
90:
91: else

Line 106: icx_util.add_error(v_error_message);

102: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
103: v_error_message := FND_MESSAGE.GET;
104: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
105: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
106: icx_util.add_error(v_error_message);
107: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
108: end if;
109: else
110: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

Line 115: icx_util.add_error(v_error_message);

111: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
112: v_error_message := FND_MESSAGE.GET;
113: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
114: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
115: icx_util.add_error(v_error_message);
116: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
117: end if;
118: l_line_number := l_line_number + 1;
119: end loop;

Line 130: icx_util.add_error(v_error_message);

126: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
127: v_error_message := FND_MESSAGE.GET || ': ' || substr(SQLERRM,1,512);
128: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
129: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_Number || ') ' || v_error_message;
130: icx_util.add_error(v_error_message);
131: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
132: end;
133:
134:

Line 356: icx_util.add_error(l_err_mesg);

352: select substr(l_error_message,12,512) into l_err_mesg from dual;
353: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
354: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
355: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
356: icx_util.add_error(l_err_mesg);
357: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,l_dist_num,v_cart_line_id);
358: if dbms_sql.IS_OPEN(v_cursor_id) then
359: dbms_sql.close_cursor(v_cursor_id);
360: end if;

Line 556: icx_util.add_error(l_err_mesg);

552: select substr(l_error_message,12,512) into l_err_mesg from dual;
553: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
554: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
555: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
556: icx_util.add_error(l_err_mesg);
557: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
558: if dbms_sql.IS_OPEN(v_cursor_id) then
559: dbms_sql.close_cursor(v_cursor_id);
560: end if;

Line 607: icx_util.add_error(v_error_message);

603: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
604: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
605: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
606: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ' ) ' || v_error_message;
607: icx_util.add_error(v_error_message);
608: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
609: end if;
610:
611:

Line 622: icx_util.add_error(v_error_message);

618: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
619: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
620: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
621: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
622: icx_util.add_error(v_error_message);
623: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
624: end;
625:
626:

Line 679: icx_util.add_error(v_error_message);

675: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
676: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
677: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
678: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
679: icx_util.add_error(v_error_message);
680: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
681: end;
682:
683:

Line 721: icx_util.add_error(v_error_message);

717: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
718: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
719: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
720: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
721: icx_util.add_error(v_error_message);
722: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
723: end if;
724:
725: -- if returns segments generate con-segs

Line 745: icx_util.add_error(v_error_message);

741: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
742: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
743: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
744: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
745: icx_util.add_error(v_error_message);
746: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
747:
748: end;
749:

Line 842: icx_util.add_error(v_error_message);

838: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
839: v_error_message := FND_MESSAGE.GET;
840: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
841: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
842: icx_util.add_error(v_error_message);
843: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
844: else
845:
846: if v_validate_flag = 'Y' then

Line 870: icx_util.add_error(v_error_message);

866: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));
867: v_error_message := FND_MESSAGE.GET;
868: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
869: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
870: icx_util.add_error(v_error_message);
871: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
872: -- icx_util.add_error(substr(SQLERRM, 12, 512));
873: end;
874:

Line 872: -- icx_util.add_error(substr(SQLERRM, 12, 512));

868: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
869: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
870: icx_util.add_error(v_error_message);
871: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
872: -- icx_util.add_error(substr(SQLERRM, 12, 512));
873: end;
874:
875:
876:

Line 977: icx_util.add_error(v_error_message);

973: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
974: v_error_message := FND_MESSAGE.GET;
975: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
976: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
977: icx_util.add_error(v_error_message);
978: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
979:
980:
981: end if;

Line 992: icx_util.add_error(v_error_message);

988: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));
989: v_error_message := FND_MESSAGE.GET;
990: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
991: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
992: icx_util.add_error(v_error_message);
993: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
994: -- icx_util.add_error(substr(SQLERRM, 12, 512));
995: end;
996:

Line 994: -- icx_util.add_error(substr(SQLERRM, 12, 512));

990: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
991: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;
992: icx_util.add_error(v_error_message);
993: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
994: -- icx_util.add_error(substr(SQLERRM, 12, 512));
995: end;
996:
997:
998:

Line 1103: icx_util.add_error(v_error_message);

1099: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1100: v_error_message := FND_MESSAGE.GET;
1101: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1102: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1103: icx_util.add_error(v_error_message);
1104: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number);
1105: else -- get con-seg based on account id
1106: get_account_segments(v_cart_id,v_line_number,v_account_id,v_structure,v_cart_line_id,l_cart_line_number,v_n_segments,v_segments,v_account_num);
1107: end if;

Line 1115: icx_util.add_error(v_error_message);

1111: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1112: v_error_message := FND_MESSAGE.GET;
1113: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1114: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1115: icx_util.add_error(v_error_message);
1116: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1117:
1118: end if;
1119:

Line 1130: icx_util.add_error(v_error_message);

1126: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1127: v_error_message := FND_MESSAGE.GET;
1128: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1129: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1130: icx_util.add_error(v_error_message);
1131: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1132: v_account_id := null;
1133: end if;
1134:

Line 1148: icx_util.add_error(v_error_message);

1144: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));
1145: v_error_message := FND_MESSAGE.GET;
1146: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1147: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1148: icx_util.add_error(v_error_message);
1149: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1150: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1151:
1152: END get_default_account;

Line 1150: -- icx_util.add_error(substr(SQLERRM, 12, 512));

1146: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1147: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1148: icx_util.add_error(v_error_message);
1149: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1150: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1151:
1152: END get_default_account;
1153:
1154:

Line 1280: icx_util.add_error(v_error_message);

1276: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
1277: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
1278: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1279: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1280: icx_util.add_error(v_error_message);
1281: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1282: end if;
1283:
1284:

Line 1293: -- icx_util.add_error(substr(SQLERRM, 12, 512));

1289: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
1290: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));
1291: v_error_message := FND_MESSAGE.GET;
1292: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1293: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1294:
1295: END get_default_segs;
1296:
1297:

Line 1379: icx_util.add_error(v_error_message);

1375: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', v_cart_line_number);
1376: v_error_message := FND_MESSAGE.GET;
1377: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1378: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1379: icx_util.add_error(v_error_message);
1380: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1381:
1382:
1383: end if;