DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT2 dependencies on ICX_REQ_SUBMIT

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

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

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

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
92: l_line_number := 1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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