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_REQ_ACCT2 dependencies on FND_MESSAGE

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

61: if v_account_id is NULL and
62: v_cart_id is NULL and
63: v_cart_line_id is NULL then
64:
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
66: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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;

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

62: v_cart_id is NULL and
63: v_cart_line_id is NULL then
64:
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
66: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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:

Line 67: v_error_message := FND_MESSAGE.GET;

63: v_cart_line_id is NULL then
64:
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
66: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN',' ');
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);

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

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

Line 69: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

78: fetch acct_exist into v_exist;
79: close acct_exist;
80: if (v_exist = 0) then
81: --add error
82: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

79: close acct_exist;
80: if (v_exist = 0) then
81: --add error
82: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 84: v_error_message := FND_MESSAGE.GET;

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

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

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

Line 86: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

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

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

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

Line 103: v_error_message := FND_MESSAGE.GET;

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

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

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

Line 105: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

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;

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

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

Line 112: v_error_message := FND_MESSAGE.GET;

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

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

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;

Line 114: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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;

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

121: end if;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

123: EXCEPTION
124: WHEN OTHERS THEN
125: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

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

Line 129: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_Number || ') ' || v_error_message;

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

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

344:
345: end if;
346: exception
347: WHEN OTHERS THEN
348: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
349: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
350: l_err_num := SQLCODE;
351: l_error_message := SQLERRM;
352: select substr(l_error_message,12,512) into l_err_mesg from dual;

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

345: end if;
346: exception
347: WHEN OTHERS THEN
348: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
349: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
350: l_err_num := SQLCODE;
351: l_error_message := SQLERRM;
352: select substr(l_error_message,12,512) into l_err_mesg from dual;
353: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;

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

349: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
350: l_err_num := SQLCODE;
351: l_error_message := SQLERRM;
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);

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

350: l_err_num := SQLCODE;
351: l_error_message := SQLERRM;
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

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

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

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

546: exception
547: WHEN OTHERS THEN
548: l_err_num := SQLCODE;
549: l_error_message := SQLERRM;
550: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
551: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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');

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

547: WHEN OTHERS THEN
548: l_err_num := SQLCODE;
549: l_error_message := SQLERRM;
550: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
551: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
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;

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

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

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

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

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

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

Line 601: v_error_message := FND_MESSAGE.GET;

597: l_account_id,
598: v_n_segments,
599: v_segments);
600: if l_ret_cd = FALSE then
601: v_error_message := FND_MESSAGE.GET;
602: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

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

598: v_n_segments,
599: v_segments);
600: if l_ret_cd = FALSE then
601: v_error_message := FND_MESSAGE.GET;
602: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

599: v_segments);
600: if l_ret_cd = FALSE then
601: v_error_message := FND_MESSAGE.GET;
602: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

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

613:
614: exception
615: when others then
616: v_error_message := substr(SQLERRM,1,512);
617: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

614: exception
615: when others then
616: v_error_message := substr(SQLERRM,1,512);
617: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

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

670:
671: exception
672: when others then
673: v_error_message := substr(SQLERRM,1,512);
674: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

671: exception
672: when others then
673: v_error_message := substr(SQLERRM,1,512);
674: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

Line 715: v_error_message := FND_MESSAGE.GET;

711: l_n_segments,
712: l_segments);
713:
714: if l_ret_cd = FALSE then
715: v_error_message := FND_MESSAGE.GET;
716: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

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

712: l_segments);
713:
714: if l_ret_cd = FALSE then
715: v_error_message := FND_MESSAGE.GET;
716: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

713:
714: if l_ret_cd = FALSE then
715: v_error_message := FND_MESSAGE.GET;
716: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

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

736: end if;
737: exception
738: when others then
739: v_error_message := substr(SQLERRM,1,512);
740: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

737: exception
738: when others then
739: v_error_message := substr(SQLERRM,1,512);
740: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

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

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

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

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

Line 839: v_error_message := FND_MESSAGE.GET;

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

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

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

Line 841: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

861: end if;
862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 867: v_error_message := FND_MESSAGE.GET;

863: EXCEPTION
864: WHEN OTHERS THEN
865: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

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

Line 869: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

968:
969: else
970:
971: --add error
972: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

969: else
970:
971: --add error
972: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 974: v_error_message := FND_MESSAGE.GET;

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

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

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

Line 976: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

983: end if;
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 989: v_error_message := FND_MESSAGE.GET;

985: EXCEPTION
986: WHEN OTHERS THEN
987: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

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

Line 991: v_error_message := '(' || FND_MESSAGE.GET || ' ' || l_line_number || ') ' || v_error_message;

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

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

1094: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
1095: and gl.CODE_COMBINATION_ID = v_account_id;
1096: if (v_exist = 0) then
1097: --add error
1098: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

1095: and gl.CODE_COMBINATION_ID = v_account_id;
1096: if (v_exist = 0) then
1097: --add error
1098: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1100: v_error_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

1107: end if;
1108: else
1109: --add error
1110: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1112: v_error_message := FND_MESSAGE.GET;

1108: else
1109: --add error
1110: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

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

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

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

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

1121: 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);
1122:
1123: if (v_account_id is null) or (v_account_id = 0) then
1124: --add error
1125: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

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

Line 1127: v_error_message := FND_MESSAGE.GET;

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

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

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

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

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

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

1139: end if;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1145: v_error_message := FND_MESSAGE.GET;

1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

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

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

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

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

Line 1274: v_error_message := FND_MESSAGE.GET;

1270:
1271: end if;
1272:
1273: if l_ret_cd = FALSE then
1274: v_error_message := FND_MESSAGE.GET;
1275: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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');

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

1271: end if;
1272:
1273: if l_ret_cd = FALSE then
1274: v_error_message := FND_MESSAGE.GET;
1275: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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;

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

1272:
1273: if l_ret_cd = FALSE then
1274: v_error_message := FND_MESSAGE.GET;
1275: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
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);

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

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

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

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

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

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

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

1285: end if;
1286:
1287: EXCEPTION
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));

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

1286:
1287: EXCEPTION
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:

Line 1291: v_error_message := FND_MESSAGE.GET;

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

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

1370: v_account_num);
1371:
1372: else
1373:
1374: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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;

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

1371:
1372: else
1373:
1374: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
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);

Line 1376: v_error_message := FND_MESSAGE.GET;

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

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

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

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

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