DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on FND_MESSAGE

Line 74: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');

70: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
71:
72: --Price Request Code corresponding to the consuming order line is mandatory.
73: IF p_cons_price_request_code IS NULL THEN
74: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
75: Fnd_Message.SET_TOKEN('PARAMETER',p_cons_price_request_code);
76: x_return_message := Fnd_Message.GET;
77: RAISE Fnd_Api.G_EXC_ERROR;
78:

Line 75: Fnd_Message.SET_TOKEN('PARAMETER',p_cons_price_request_code);

71:
72: --Price Request Code corresponding to the consuming order line is mandatory.
73: IF p_cons_price_request_code IS NULL THEN
74: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
75: Fnd_Message.SET_TOKEN('PARAMETER',p_cons_price_request_code);
76: x_return_message := Fnd_Message.GET;
77: RAISE Fnd_Api.G_EXC_ERROR;
78:
79: END IF;

Line 76: x_return_message := Fnd_Message.GET;

72: --Price Request Code corresponding to the consuming order line is mandatory.
73: IF p_cons_price_request_code IS NULL THEN
74: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
75: Fnd_Message.SET_TOKEN('PARAMETER',p_cons_price_request_code);
76: x_return_message := Fnd_Message.GET;
77: RAISE Fnd_Api.G_EXC_ERROR;
78:
79: END IF;
80:

Line 84: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');

80:
81: --Action Code is mandatory.
82: IF p_action_code IS NULL THEN
83:
84: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
85: Fnd_Message.SET_TOKEN('PARAMETER',p_action_code);
86: x_return_message := Fnd_Message.GET;
87: RAISE Fnd_Api.G_EXC_ERROR;
88:

Line 85: Fnd_Message.SET_TOKEN('PARAMETER',p_action_code);

81: --Action Code is mandatory.
82: IF p_action_code IS NULL THEN
83:
84: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
85: Fnd_Message.SET_TOKEN('PARAMETER',p_action_code);
86: x_return_message := Fnd_Message.GET;
87: RAISE Fnd_Api.G_EXC_ERROR;
88:
89: END IF;

Line 86: x_return_message := Fnd_Message.GET;

82: IF p_action_code IS NULL THEN
83:
84: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
85: Fnd_Message.SET_TOKEN('PARAMETER',p_action_code);
86: x_return_message := Fnd_Message.GET;
87: RAISE Fnd_Api.G_EXC_ERROR;
88:
89: END IF;
90:

Line 95: Fnd_Message.SET_NAME('QP','QP_NONZERO_PARAMETER_REQD');

91: --Originally ordered qty must be not-null and non-zero.
92: IF p_action_code <> 'CANCEL' AND
93: (p_orig_ordered_qty IS NULL OR p_orig_ordered_qty = 0) THEN
94:
95: Fnd_Message.SET_NAME('QP','QP_NONZERO_PARAMETER_REQD');
96: Fnd_Message.SET_TOKEN('PARAMETER',p_orig_ordered_qty);
97: x_return_message := Fnd_Message.GET;
98: RAISE Fnd_Api.G_EXC_ERROR;
99:

Line 96: Fnd_Message.SET_TOKEN('PARAMETER',p_orig_ordered_qty);

92: IF p_action_code <> 'CANCEL' AND
93: (p_orig_ordered_qty IS NULL OR p_orig_ordered_qty = 0) THEN
94:
95: Fnd_Message.SET_NAME('QP','QP_NONZERO_PARAMETER_REQD');
96: Fnd_Message.SET_TOKEN('PARAMETER',p_orig_ordered_qty);
97: x_return_message := Fnd_Message.GET;
98: RAISE Fnd_Api.G_EXC_ERROR;
99:
100: END IF;

Line 97: x_return_message := Fnd_Message.GET;

93: (p_orig_ordered_qty IS NULL OR p_orig_ordered_qty = 0) THEN
94:
95: Fnd_Message.SET_NAME('QP','QP_NONZERO_PARAMETER_REQD');
96: Fnd_Message.SET_TOKEN('PARAMETER',p_orig_ordered_qty);
97: x_return_message := Fnd_Message.GET;
98: RAISE Fnd_Api.G_EXC_ERROR;
99:
100: END IF;
101:

Line 105: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');

101:
102: --If Action Code is 'RETURN' then the returned qty must be not null.
103: IF p_action_code = 'RETURN' AND p_returned_qty IS NULL THEN
104:
105: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
106: Fnd_Message.SET_TOKEN('PARAMETER',p_returned_qty);
107: x_return_message := Fnd_Message.GET;
108: RAISE Fnd_Api.G_EXC_ERROR;
109:

Line 106: Fnd_Message.SET_TOKEN('PARAMETER',p_returned_qty);

102: --If Action Code is 'RETURN' then the returned qty must be not null.
103: IF p_action_code = 'RETURN' AND p_returned_qty IS NULL THEN
104:
105: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
106: Fnd_Message.SET_TOKEN('PARAMETER',p_returned_qty);
107: x_return_message := Fnd_Message.GET;
108: RAISE Fnd_Api.G_EXC_ERROR;
109:
110: END IF;

Line 107: x_return_message := Fnd_Message.GET;

103: IF p_action_code = 'RETURN' AND p_returned_qty IS NULL THEN
104:
105: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
106: Fnd_Message.SET_TOKEN('PARAMETER',p_returned_qty);
107: x_return_message := Fnd_Message.GET;
108: RAISE Fnd_Api.G_EXC_ERROR;
109:
110: END IF;
111:

Line 116: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');

112: --If Action Code is 'RETURN' then the price_request_code of the return
113: --line must be not null.
114: IF p_action_code = 'RETURN' AND p_ret_price_request_code IS NULL THEN
115:
116: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
117: Fnd_Message.SET_TOKEN('PARAMETER',p_ret_price_request_code);
118: x_return_message := Fnd_Message.GET;
119: RAISE Fnd_Api.G_EXC_ERROR;
120:

Line 117: Fnd_Message.SET_TOKEN('PARAMETER',p_ret_price_request_code);

113: --line must be not null.
114: IF p_action_code = 'RETURN' AND p_ret_price_request_code IS NULL THEN
115:
116: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
117: Fnd_Message.SET_TOKEN('PARAMETER',p_ret_price_request_code);
118: x_return_message := Fnd_Message.GET;
119: RAISE Fnd_Api.G_EXC_ERROR;
120:
121: END IF;

Line 118: x_return_message := Fnd_Message.GET;

114: IF p_action_code = 'RETURN' AND p_ret_price_request_code IS NULL THEN
115:
116: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
117: Fnd_Message.SET_TOKEN('PARAMETER',p_ret_price_request_code);
118: x_return_message := Fnd_Message.GET;
119: RAISE Fnd_Api.G_EXC_ERROR;
120:
121: END IF;
122:

Line 126: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');

122:
123: --If Action Code is 'AMEND' then the amended qty must be not null.
124: IF p_action_code = 'AMEND' AND p_amended_qty IS NULL THEN
125:
126: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
127: Fnd_Message.SET_TOKEN('PARAMETER',p_amended_qty);
128: x_return_message := Fnd_Message.GET;
129: RAISE Fnd_Api.G_EXC_ERROR;
130:

Line 127: Fnd_Message.SET_TOKEN('PARAMETER',p_amended_qty);

123: --If Action Code is 'AMEND' then the amended qty must be not null.
124: IF p_action_code = 'AMEND' AND p_amended_qty IS NULL THEN
125:
126: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
127: Fnd_Message.SET_TOKEN('PARAMETER',p_amended_qty);
128: x_return_message := Fnd_Message.GET;
129: RAISE Fnd_Api.G_EXC_ERROR;
130:
131: END IF;

Line 128: x_return_message := Fnd_Message.GET;

124: IF p_action_code = 'AMEND' AND p_amended_qty IS NULL THEN
125:
126: Fnd_Message.SET_NAME('QP','QP_PARAMETER_REQUIRED');
127: Fnd_Message.SET_TOKEN('PARAMETER',p_amended_qty);
128: x_return_message := Fnd_Message.GET;
129: RAISE Fnd_Api.G_EXC_ERROR;
130:
131: END IF;
132:

Line 137: Fnd_Message.SET_NAME('QP','QP_PARAMETER_MUST_BE_LESSER');

133: --If Action Code is 'AMEND' then the amended qty must not be greater
134: --than the orignally ordered qty.
135: IF p_action_code = 'AMEND' AND p_amended_qty > p_orig_ordered_qty THEN
136:
137: Fnd_Message.SET_NAME('QP','QP_PARAMETER_MUST_BE_LESSER');
138: Fnd_Message.SET_TOKEN('PARAMETER1',p_amended_qty);
139: Fnd_Message.SET_TOKEN('PARAMETER2',p_orig_ordered_qty);
140: x_return_message := Fnd_Message.GET;
141: RAISE Fnd_Api.G_EXC_ERROR;

Line 138: Fnd_Message.SET_TOKEN('PARAMETER1',p_amended_qty);

134: --than the orignally ordered qty.
135: IF p_action_code = 'AMEND' AND p_amended_qty > p_orig_ordered_qty THEN
136:
137: Fnd_Message.SET_NAME('QP','QP_PARAMETER_MUST_BE_LESSER');
138: Fnd_Message.SET_TOKEN('PARAMETER1',p_amended_qty);
139: Fnd_Message.SET_TOKEN('PARAMETER2',p_orig_ordered_qty);
140: x_return_message := Fnd_Message.GET;
141: RAISE Fnd_Api.G_EXC_ERROR;
142:

Line 139: Fnd_Message.SET_TOKEN('PARAMETER2',p_orig_ordered_qty);

135: IF p_action_code = 'AMEND' AND p_amended_qty > p_orig_ordered_qty THEN
136:
137: Fnd_Message.SET_NAME('QP','QP_PARAMETER_MUST_BE_LESSER');
138: Fnd_Message.SET_TOKEN('PARAMETER1',p_amended_qty);
139: Fnd_Message.SET_TOKEN('PARAMETER2',p_orig_ordered_qty);
140: x_return_message := Fnd_Message.GET;
141: RAISE Fnd_Api.G_EXC_ERROR;
142:
143: END IF;

Line 140: x_return_message := Fnd_Message.GET;

136:
137: Fnd_Message.SET_NAME('QP','QP_PARAMETER_MUST_BE_LESSER');
138: Fnd_Message.SET_TOKEN('PARAMETER1',p_amended_qty);
139: Fnd_Message.SET_TOKEN('PARAMETER2',p_orig_ordered_qty);
140: x_return_message := Fnd_Message.GET;
141: RAISE Fnd_Api.G_EXC_ERROR;
142:
143: END IF;
144:

Line 159: Fnd_Message.SET_NAME('QP','QP_INVALID_ACTION_CODE');

155: ELSIF p_action_code = 'SPLIT_NEW' THEN
156: l_proration := p_returned_qty/p_orig_ordered_qty;
157: --bug#7540503
158: ELSE
159: Fnd_Message.SET_NAME('QP','QP_INVALID_ACTION_CODE');
160: x_return_message := Fnd_Message.GET;
161: RAISE Fnd_Api.G_EXC_ERROR;
162: END IF;
163:

Line 160: x_return_message := Fnd_Message.GET;

156: l_proration := p_returned_qty/p_orig_ordered_qty;
157: --bug#7540503
158: ELSE
159: Fnd_Message.SET_NAME('QP','QP_INVALID_ACTION_CODE');
160: x_return_message := Fnd_Message.GET;
161: RAISE Fnd_Api.G_EXC_ERROR;
162: END IF;
163:
164:

Line 257: Fnd_Message.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');

253: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;
254:
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: Fnd_Message.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');
258: x_return_message := Fnd_Message.GET;
259: RAISE Fnd_Api.G_EXC_ERROR;
260: END;
261:

Line 258: x_return_message := Fnd_Message.GET;

254:
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: Fnd_Message.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');
258: x_return_message := Fnd_Message.GET;
259: RAISE Fnd_Api.G_EXC_ERROR;
260: END;
261:
262: --Transaction Record to be cancelled/amended exists. Update trxn amount.

Line 346: FND_MESSAGE.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');

342: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;
343:
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');
347: x_return_message := FND_MESSAGE.GET;
348: RAISE FND_API.G_EXC_ERROR;
349: END;
350:

Line 347: x_return_message := FND_MESSAGE.GET;

343:
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');
347: x_return_message := FND_MESSAGE.GET;
348: RAISE FND_API.G_EXC_ERROR;
349: END;
350:
351: --Transaction Record to be updated exists. Update trxn amount.

Line 782: Fnd_Message.SET_NAME('QP', 'QP_ERR_VALID_PRICELIST_N_CURR');

778: WHEN OTHERS THEN
779: l_validate_result := 'N';
780:
781: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
782: Fnd_Message.SET_NAME('QP', 'QP_ERR_VALID_PRICELIST_N_CURR');
783: END IF;
784:
785: IF c_validate_plist_curr_multi%ISOPEN THEN
786: CLOSE c_validate_plist_curr_multi;

Line 913: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_CURR_F_PRICELIST');

909:
910: WHEN OTHERS THEN
911:
912: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
913: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_CURR_F_PRICELIST');
914: END IF;
915:
916: IF c_currency_multi%ISOPEN THEN
917: CLOSE c_currency_multi;

Line 1365: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICELIST_F_CURR');

1361: EXCEPTION
1362: WHEN OTHERS THEN
1363:
1364: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1365: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICELIST_F_CURR');
1366: END IF;
1367:
1368: IF c_price_list_multi%ISOPEN THEN
1369: CLOSE c_price_list_multi;

Line 1500: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');

1496: EXCEPTION
1497: WHEN OTHERS THEN
1498:
1499: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1500: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');
1501: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Price Lists');
1502: END IF;
1503:
1504: IF c_price_list_blkt%ISOPEN THEN

Line 1501: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Price Lists');

1497: WHEN OTHERS THEN
1498:
1499: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1500: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');
1501: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Price Lists');
1502: END IF;
1503:
1504: IF c_price_list_blkt%ISOPEN THEN
1505: CLOSE c_price_list_blkt;

Line 1767: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');

1763: EXCEPTION
1764: WHEN OTHERS THEN
1765:
1766: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1767: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');
1768: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Agreements');
1769: END IF;
1770:
1771: IF c_agreement%ISOPEN THEN

Line 1768: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Agreements');

1764: WHEN OTHERS THEN
1765:
1766: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1767: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_PRICING_OBJECT');
1768: Fnd_Message.SET_TOKEN('PRICING_OBJECT','Agreements');
1769: END IF;
1770:
1771: IF c_agreement%ISOPEN THEN
1772: CLOSE c_agreement;

Line 1877: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

1873:
1874: END IF;
1875: IF p_operand_type <> 'R' AND p_operand IS NULL THEN
1876: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_ERROR) THEN
1877: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1878: Fnd_Message.SET_TOKEN('ATTRIBUTE','Operand');
1879: Oe_Msg_Pub.ADD;
1880: END IF;
1881: RAISE Fnd_Api.G_EXC_ERROR;

Line 1878: Fnd_Message.SET_TOKEN('ATTRIBUTE','Operand');

1874: END IF;
1875: IF p_operand_type <> 'R' AND p_operand IS NULL THEN
1876: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_ERROR) THEN
1877: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1878: Fnd_Message.SET_TOKEN('ATTRIBUTE','Operand');
1879: Oe_Msg_Pub.ADD;
1880: END IF;
1881: RAISE Fnd_Api.G_EXC_ERROR;
1882: END IF;

Line 2076: Fnd_Message.SET_NAME('QP','QP_NO_RECORD_FOR_ROUNDING');

2072: Oe_Debug_Pub.ADD('round_price - NO_DATA_FOUND exception');
2073: END IF;
2074: x_status_code := Fnd_Api.G_RET_STS_ERROR;
2075: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2076: Fnd_Message.SET_NAME('QP','QP_NO_RECORD_FOR_ROUNDING');
2077: Fnd_Message.SET_TOKEN('PRICE_LIST', p_price_list_id);
2078: Fnd_Message.SET_TOKEN('CURRENCY', p_currency_code);
2079: END IF;
2080:

Line 2077: Fnd_Message.SET_TOKEN('PRICE_LIST', p_price_list_id);

2073: END IF;
2074: x_status_code := Fnd_Api.G_RET_STS_ERROR;
2075: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2076: Fnd_Message.SET_NAME('QP','QP_NO_RECORD_FOR_ROUNDING');
2077: Fnd_Message.SET_TOKEN('PRICE_LIST', p_price_list_id);
2078: Fnd_Message.SET_TOKEN('CURRENCY', p_currency_code);
2079: END IF;
2080:
2081: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2078: Fnd_Message.SET_TOKEN('CURRENCY', p_currency_code);

2074: x_status_code := Fnd_Api.G_RET_STS_ERROR;
2075: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2076: Fnd_Message.SET_NAME('QP','QP_NO_RECORD_FOR_ROUNDING');
2077: Fnd_Message.SET_TOKEN('PRICE_LIST', p_price_list_id);
2078: Fnd_Message.SET_TOKEN('CURRENCY', p_currency_code);
2079: END IF;
2080:
2081: WHEN Fnd_Api.G_EXC_ERROR THEN
2082:

Line 2505: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_CURR_F_PRICELIST');

2501:
2502: EXCEPTION
2503: WHEN OTHERS THEN
2504: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2505: Fnd_Message.SET_NAME('QP', 'QP_ERROR_GET_CURR_F_PRICELIST');
2506: END IF;
2507:
2508: END Get_Price_List_Currency;
2509: