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;
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
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');
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;
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:
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;
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;
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:
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:
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:
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
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:
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
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:
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:
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;
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:
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:
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;
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:
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:
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;
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:
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:
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:
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;