eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_PO_REQ_ACCT2 dependencies on FND_MESSAGE

Line 83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

79: if v_account_id is NULL and
80: v_cart_id is NULL and
81: v_cart_line_id is NULL then
82:
83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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;

Line 84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');

80: v_cart_id is NULL and
81: v_cart_line_id is NULL then
82:
83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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:

Line 85: v_error_message := FND_MESSAGE.GET;

81: v_cart_line_id is NULL then
82:
83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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);

Line 86: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

82:
83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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);

Line 87: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

83: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
84: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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:

Line 100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

96: fetch acct_exist into v_exist;
97: close acct_exist;
98: if (v_exist = 0) then
99: --add error
100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 101: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

97: close acct_exist;
98: if (v_exist = 0) then
99: --add error
100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 102: v_error_message := FND_MESSAGE.GET;

98: if (v_exist = 0) then
99: --add error
100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 103: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

99: --add error
100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 104: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

100: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

115: fetch acct_exist into v_exist;
116: close acct_exist;
117: if (v_exist = 0) then
118: --add error
119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 120: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

116: close acct_exist;
117: if (v_exist = 0) then
118: --add error
119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 121: v_error_message := FND_MESSAGE.GET;

117: if (v_exist = 0) then
118: --add error
119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 122: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

118: --add error
119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 123: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

119: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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

Line 128: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

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

Line 129: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

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

Line 130: v_error_message := FND_MESSAGE.GET;

126: end if;
127: else
128: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 131: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

127: else
128: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 132: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

128: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

139: end if;
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 144: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 145: v_error_message := FND_MESSAGE.GET || ': ' || substr(SQLERRM,1,512);

141: EXCEPTION
142: WHEN OTHERS THEN
143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 146: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

142: WHEN OTHERS THEN
143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 147: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 403: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

399:
400: end if;
401: exception
402: WHEN OTHERS THEN
403: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
404: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);
405: l_err_num := SQLCODE;
406: l_error_message := SQLERRM;
407: select substr(l_error_message,12,512) into l_err_mesg from dual;

Line 404: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);

400: end if;
401: exception
402: WHEN OTHERS THEN
403: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
404: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);
405: l_err_num := SQLCODE;
406: l_error_message := SQLERRM;
407: select substr(l_error_message,12,512) into l_err_mesg from dual;
408: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;

Line 408: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;

404: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);
405: l_err_num := SQLCODE;
406: l_error_message := SQLERRM;
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);

Line 409: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

405: l_err_num := SQLCODE;
406: l_error_message := SQLERRM;
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:

Line 410: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;

406: l_error_message := SQLERRM;
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;

Line 598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

594: exception
595: WHEN OTHERS THEN
596: l_err_num := SQLCODE;
597: l_error_message := SQLERRM;
598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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');

Line 599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);

595: WHEN OTHERS THEN
596: l_err_num := SQLCODE;
597: l_error_message := SQLERRM;
598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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;

Line 601: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;

597: l_error_message := SQLERRM;
598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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);

Line 602: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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

Line 603: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;

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

Line 649: v_error_message := FND_MESSAGE.GET;

645: l_account_id,
646: v_n_segments,
647: v_segments);
648: if l_ret_cd = FALSE then
649: v_error_message := FND_MESSAGE.GET;
650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

Line 650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

646: v_n_segments,
647: v_segments);
648: if l_ret_cd = FALSE then
649: v_error_message := FND_MESSAGE.GET;
650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 651: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);

647: v_segments);
648: if l_ret_cd = FALSE then
649: v_error_message := FND_MESSAGE.GET;
650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 652: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

648: if l_ret_cd = FALSE then
649: v_error_message := FND_MESSAGE.GET;
650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 653: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

649: v_error_message := FND_MESSAGE.GET;
650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 654: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ' ) ' || v_error_message;

650: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

661:
662: exception
663: when others then
664: v_error_message := substr(SQLERRM,1,512);
665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 666: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);

662: exception
663: when others then
664: v_error_message := substr(SQLERRM,1,512);
665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 667: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

663: when others then
664: v_error_message := substr(SQLERRM,1,512);
665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 668: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

664: v_error_message := substr(SQLERRM,1,512);
665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 669: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

665: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

718:
719: exception
720: when others then
721: v_error_message := substr(SQLERRM,1,512);
722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 723: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);

719: exception
720: when others then
721: v_error_message := substr(SQLERRM,1,512);
722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 724: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

720: when others then
721: v_error_message := substr(SQLERRM,1,512);
722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 725: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

721: v_error_message := substr(SQLERRM,1,512);
722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 726: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

722: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 763: v_error_message := FND_MESSAGE.GET;

759: l_n_segments,
760: l_segments);
761:
762: if l_ret_cd = FALSE then
763: v_error_message := FND_MESSAGE.GET;
764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

Line 764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

760: l_segments);
761:
762: if l_ret_cd = FALSE then
763: v_error_message := FND_MESSAGE.GET;
764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 765: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);

761:
762: if l_ret_cd = FALSE then
763: v_error_message := FND_MESSAGE.GET;
764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 766: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

762: if l_ret_cd = FALSE then
763: v_error_message := FND_MESSAGE.GET;
764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 767: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

763: v_error_message := FND_MESSAGE.GET;
764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 768: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

764: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

784: end if;
785: exception
786: when others then
787: v_error_message := substr(SQLERRM,1,512);
788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 789: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',v_cart_line_number);

785: exception
786: when others then
787: v_error_message := substr(SQLERRM,1,512);
788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 790: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

786: when others then
787: v_error_message := substr(SQLERRM,1,512);
788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 791: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

787: v_error_message := substr(SQLERRM,1,512);
788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 792: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

889:
890: /* if the account number passing in does not generate a valid account id
891: error out immediately */
892: if v_account_id is NULL then
893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 894: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number);

890: /* if the account number passing in does not generate a valid account id
891: error out immediately */
892: if v_account_id is NULL then
893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 895: v_error_message := FND_MESSAGE.GET;

891: error out immediately */
892: if v_account_id is NULL then
893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 896: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

892: if v_account_id is NULL then
893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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

Line 897: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

893: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

917: end if;
918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 922: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_line_number || ': ' || substr(SQLERRM,1,512));

918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 923: v_error_message := FND_MESSAGE.GET;

919: EXCEPTION
920: WHEN OTHERS THEN
921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 924: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

920: WHEN OTHERS THEN
921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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));

Line 925: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

921: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1045:
1046: else
1047:
1048: --add error
1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1050: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number);

1046: else
1047:
1048: --add error
1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1051: v_error_message := FND_MESSAGE.GET;

1047:
1048: --add error
1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1052: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1048: --add error
1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 1053: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

1049: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1060: end if;
1061:
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1065: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number || ': ' || substr(SQLERRM,1,512));

1061:
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1066: v_error_message := FND_MESSAGE.GET;

1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1067: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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));

Line 1068: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_dist_number || ') ' || v_error_message;

1064: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1171: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
1172: and gl.CODE_COMBINATION_ID = v_account_id;
1173: if (v_exist = 0) then
1174: --add error
1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1176: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);

1172: and gl.CODE_COMBINATION_ID = v_account_id;
1173: if (v_exist = 0) then
1174: --add error
1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1177: v_error_message := FND_MESSAGE.GET;

1173: if (v_exist = 0) then
1174: --add error
1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1178: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1174: --add error
1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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

Line 1179: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1175: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

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
1186: --add error
1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1188: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);

1184: end if;
1185: else
1186: --add error
1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1189: v_error_message := FND_MESSAGE.GET;

1185: else
1186: --add error
1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1190: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1186: --add error
1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 1191: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1187: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1198: get_acct_by_con(v_cart_id,v_line_number,v_account_num,v_structure,v_cart_line_id,l_cart_line_number,v_n_segments,v_segments,v_account_id);
1199:
1200: if (v_account_id is null) or (v_account_id = 0) then
1201: --add error
1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1203: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number);

1199:
1200: if (v_account_id is null) or (v_account_id = 0) then
1201: --add error
1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1204: v_error_message := FND_MESSAGE.GET;

1200: if (v_account_id is null) or (v_account_id = 0) then
1201: --add error
1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1205: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1201: --add error
1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1206: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1202: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1216: end if;
1217:
1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1221: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_cart_line_number || ': ' || substr(SQLERRM,1,512));

1217:
1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1222: v_error_message := FND_MESSAGE.GET;

1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1223: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1219: WHEN OTHERS THEN
1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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));

Line 1224: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1220: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 1355: v_error_message := FND_MESSAGE.GET;

1351:
1352: end if;
1353:
1354: if l_ret_cd = FALSE then
1355: v_error_message := FND_MESSAGE.GET;
1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

Line 1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');

1352: end if;
1353:
1354: if l_ret_cd = FALSE then
1355: v_error_message := FND_MESSAGE.GET;
1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 1357: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);

1353:
1354: if l_ret_cd = FALSE then
1355: v_error_message := FND_MESSAGE.GET;
1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 1358: v_error_message := FND_MESSAGE.GET || ' ' || v_error_message;

1354: if l_ret_cd = FALSE then
1355: v_error_message := FND_MESSAGE.GET;
1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

Line 1359: -- FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1355: v_error_message := FND_MESSAGE.GET;
1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

Line 1360: -- v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1356: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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:

Line 1370: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1366: end if;
1367:
1368: EXCEPTION
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));

Line 1371: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', l_req_line_number || ': ' || substr(SQLERRM,1,512));

1367:
1368: EXCEPTION
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:

Line 1372: v_error_message := FND_MESSAGE.GET;

1368: EXCEPTION
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;

Line 1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');

1451: v_account_num);
1452:
1453: else
1454:
1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

Line 1456: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', v_cart_line_number);

1452:
1453: else
1454:
1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1457: v_error_message := FND_MESSAGE.GET;

1453: else
1454:
1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1458: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');

1454:
1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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:

Line 1459: v_error_message := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || v_error_message;

1455: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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: