DBA Data[Home] [Help]

APPS.ICX_PO_REQ_ACCT2 dependencies on ICX_UTIL

Line 89: icx_util.add_error(v_error_message);

85: v_error_message := FND_MESSAGE.GET;
86: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
87: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
88:
89: icx_util.add_error(v_error_message);
90: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number);
91:
92: elsif v_account_id is not NULL then
93: l_account_id := v_account_id;

Line 105: icx_util.add_error(v_error_message);

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

Line 124: icx_util.add_error(v_error_message);

120: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);
121: v_error_message := FND_MESSAGE.GET;
122: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
123: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
124: icx_util.add_error(v_error_message);
125: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
126: end if;
127: else
128: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

Line 133: icx_util.add_error(v_error_message);

129: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);
130: v_error_message := FND_MESSAGE.GET;
131: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
132: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
133: icx_util.add_error(v_error_message);
134: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
135: end if;
136: l_dist_number := l_dist_number + 1;
137: end loop;

Line 148: icx_util.add_error(v_error_message);

144: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);
145: v_error_message := FND_MESSAGE.GET || ': ' || substr(SQLERRM,1,512);
146: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
147: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
148: icx_util.add_error(v_error_message);
149: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
150: end;
151:
152:

Line 411: icx_util.add_error(l_err_mesg);

407: select substr(l_error_message,12,512) into l_err_mesg from dual;
408: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
409: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
410: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
411: icx_util.add_error(l_err_mesg);
412: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,l_dist_num,v_cart_line_id);
413:
414: end;
415:

Line 604: icx_util.add_error(l_err_mesg);

600: select substr(l_error_message,12,512) into l_err_mesg from dual;
601: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
602: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
603: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
604: icx_util.add_error(l_err_mesg);
605: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
606: if dbms_sql.IS_OPEN(v_cursor_id) then
607: dbms_sql.close_cursor(v_cursor_id);
608: end if;

Line 655: icx_util.add_error(v_error_message);

651: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
652: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
653: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
654: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ' ) ' || v_error_message;
655: icx_util.add_error(v_error_message);
656: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
657: end if;
658:
659:

Line 670: icx_util.add_error(v_error_message);

666: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
667: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
668: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
669: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
670: icx_util.add_error(v_error_message);
671: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
672: end;
673:
674:

Line 727: icx_util.add_error(v_error_message);

723: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
724: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
725: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
726: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
727: icx_util.add_error(v_error_message);
728: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
729: end;
730:
731:

Line 769: icx_util.add_error(v_error_message);

765: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
766: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
767: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
768: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
769: icx_util.add_error(v_error_message);
770: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
771: end if;
772:
773: -- if returns segments generate con-segs

Line 793: icx_util.add_error(v_error_message);

789: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);
790: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
791: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
792: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
793: icx_util.add_error(v_error_message);
794: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
795:
796: end;
797:

Line 898: icx_util.add_error(v_error_message);

894: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);
895: v_error_message := FND_MESSAGE.GET;
896: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
897: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
898: icx_util.add_error(v_error_message);
899: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
900: else
901:
902: if v_validate_flag = 'Y' then

Line 926: icx_util.add_error(v_error_message);

922: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number || ': ' || substr(SQLERRM,1,512));
923: v_error_message := FND_MESSAGE.GET;
924: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
925: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
926: icx_util.add_error(v_error_message);
927: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
928: icx_util.add_error(substr(SQLERRM, 12, 512));
929: end;
930:

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

924: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
925: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
926: icx_util.add_error(v_error_message);
927: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
928: icx_util.add_error(substr(SQLERRM, 12, 512));
929: end;
930:
931:
932:

Line 1054: icx_util.add_error(v_error_message);

1050: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number);
1051: v_error_message := FND_MESSAGE.GET;
1052: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1053: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
1054: icx_util.add_error(v_error_message);
1055: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
1056:
1057:
1058: end if;

Line 1069: icx_util.add_error(v_error_message);

1065: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number || ': ' || substr(SQLERRM,1,512));
1066: v_error_message := FND_MESSAGE.GET;
1067: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1068: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
1069: icx_util.add_error(v_error_message);
1070: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
1071: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1072: end;
1073:

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

1067: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1068: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;
1069: icx_util.add_error(v_error_message);
1070: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);
1071: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1072: end;
1073:
1074:
1075:

Line 1180: icx_util.add_error(v_error_message);

1176: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1177: v_error_message := FND_MESSAGE.GET;
1178: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1179: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1180: icx_util.add_error(v_error_message);
1181: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number);
1182: else -- get con-seg based on account id
1183: 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);
1184: end if;

Line 1192: icx_util.add_error(v_error_message);

1188: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1189: v_error_message := FND_MESSAGE.GET;
1190: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1191: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1192: icx_util.add_error(v_error_message);
1193: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1194:
1195: end if;
1196:

Line 1207: icx_util.add_error(v_error_message);

1203: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);
1204: v_error_message := FND_MESSAGE.GET;
1205: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1206: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1207: icx_util.add_error(v_error_message);
1208: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1209: v_account_id := null;
1210: end if;
1211:

Line 1225: icx_util.add_error(v_error_message);

1221: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));
1222: v_error_message := FND_MESSAGE.GET;
1223: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1224: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1225: icx_util.add_error(v_error_message);
1226: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1227: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1228:
1229: END get_default_account;

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

1223: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1224: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1225: icx_util.add_error(v_error_message);
1226: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1227: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1228:
1229: END get_default_account;
1230:
1231:

Line 1361: icx_util.add_error(v_error_message);

1357: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);
1358: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;
1359: -- FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1360: -- v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1361: icx_util.add_error(v_error_message);
1362: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1363: end if;
1364:
1365:

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

1370: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
1371: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number || ': ' || substr(SQLERRM,1,512));
1372: v_error_message := FND_MESSAGE.GET;
1373: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1374: -- icx_util.add_error(substr(SQLERRM, 12, 512));
1375:
1376: END get_default_segs;
1377:
1378:

Line 1460: icx_util.add_error(v_error_message);

1456: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', v_cart_line_number);
1457: v_error_message := FND_MESSAGE.GET;
1458: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
1459: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;
1460: icx_util.add_error(v_error_message);
1461: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);
1462:
1463:
1464: end if;