DBA Data[Home] [Help]

APPS.ICX_PO_REQ_ACCT2 dependencies on ICX_REQ_SUBMIT

Line 90: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number);

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;
94:

Line 106: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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
110: l_dist_number := 1;

Line 125: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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');
129: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

Line 134: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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;
138: end if;

Line 149: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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:
153: PROCEDURE insert_row(v_cart_line_id IN NUMBER,

Line 412: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,l_dist_num,v_cart_line_id);

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:
416:

Line 605: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);

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;
609: end;

Line 656: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
660: end if;

Line 671: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
675: /* get account id,con-catenated segments based on segments */

Line 728: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
732: /* main procedure to call to get segments,concatenated segments based on an

Line 770: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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
774: if l_n_segments is not NULL and

Line 794: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
798:

Line 899: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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
903: validate_charge_account(v_cart_id,v_cart_line_id,l_line_number,v_account_id, v_oo_id);

Line 927: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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:
931:

Line 1055: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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;
1059:

Line 1070: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,l_line_number,v_cart_line_id);

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:
1074:

Line 1181: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_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;
1185: else

Line 1193: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
1197: elsif v_account_num is not NULL then

Line 1208: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
1212: end if;

Line 1226: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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;
1230:

Line 1362: -- ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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:
1366: end if;

Line 1373: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

1369: WHEN OTHERS THEN
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:

Line 1461: ICX_REQ_SUBMIT.storeerror(v_cart_id, v_error_message,v_line_number,v_cart_line_id);

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;
1465: