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.CSD_PROCESS_UTIL dependencies on FND_MSG_PUB

Line 37: FND_MSG_PUB.Add;

33: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
34: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
35: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
36: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
41: END Check_Reqd_Param;

Line 56: FND_MSG_PUB.Add;

52: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
54: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
55: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
56: FND_MSG_PUB.Add;
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59:
60: END Check_Reqd_Param;

Line 75: FND_MSG_PUB.Add;

71: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
72: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
73: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
74: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
75: FND_MSG_PUB.Add;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
79: END Check_Reqd_Param;

Line 99: FND_MSG_PUB.Add;

95: Exception
96: When No_data_found then
97: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
98: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
103: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 104: FND_MSG_PUB.Add;

100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
103: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: End;
107: END Get_No_Chg_Flag;
108:

Line 124: FND_MSG_PUB.Add;

120: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
121: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
122: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
123: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
124: FND_MSG_PUB.Add;
125: RETURN FALSE;
126: ELSE
127: RETURN TRUE;
128: END IF;

Line 135: FND_MSG_PUB.Add;

131: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
132: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
133: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
134: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
135: FND_MSG_PUB.Add;
136: RETURN FALSE;
137: ELSE
138: RETURN TRUE;
139: END IF;

Line 169: FND_MSG_PUB.Add;

165: EXCEPTION
166: When NO_DATA_FOUND then
167: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
168: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
169: FND_MSG_PUB.Add;
170: RETURN FALSE;
171: END Validate_incident_id;
172:
173: FUNCTION Validate_repair_type_id

Line 195: FND_MSG_PUB.Add;

191: EXCEPTION
192: When NO_DATA_FOUND then
193: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
194: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
195: FND_MSG_PUB.Add;
196: RETURN FALSE;
197: END Validate_repair_type_id;
198:
199: FUNCTION Validate_wip_entity_id

Line 219: FND_MSG_PUB.Add;

215: EXCEPTION
216: When NO_DATA_FOUND then
217: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
218: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
219: FND_MSG_PUB.Add;
220: RETURN FALSE;
221: END Validate_wip_entity_id;
222:
223: FUNCTION Validate_repair_group_id

Line 243: FND_MSG_PUB.Add;

239: EXCEPTION
240: When NO_DATA_FOUND then
241: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
242: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
243: FND_MSG_PUB.Add;
244: RETURN FALSE;
245: END Validate_repair_group_id;
246:
247: FUNCTION Validate_ro_job_date

Line 267: FND_MSG_PUB.Add;

263: EXCEPTION
264: When NO_DATA_FOUND then
265: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
266: FND_MESSAGE.SET_TOKEN('DATE',p_date);
267: FND_MSG_PUB.Add;
268: RETURN FALSE;
269: When TOO_MANY_ROWS then
270: RETURN TRUE;
271: END Validate_ro_job_date;

Line 299: FND_MSG_PUB.Add;

295: EXCEPTION
296: When NO_DATA_FOUND then
297: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
298: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
299: FND_MSG_PUB.Add;
300: RETURN FALSE;
301: END Validate_inventory_item_id;
302:
303: FUNCTION Validate_Unit_of_measure

Line 326: FND_MSG_PUB.Add;

322: EXCEPTION
323: When NO_DATA_FOUND then
324: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
325: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
326: FND_MSG_PUB.Add;
327: END Validate_Unit_of_measure;
328:
329:
330: PROCEDURE Convert_Est_to_Chg_rec

Line 533: FND_MSG_PUB.Add;

529: WHEN NO_DATA_FOUND THEN
530: x_return_status := FND_API.G_RET_STS_ERROR ;
531: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
532: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
533: FND_MSG_PUB.Add;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
536: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
537: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

Line 538: FND_MSG_PUB.Add;

534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
536: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
537: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
538: FND_MSG_PUB.Add;
539: END get_incident_id;
540:
541:
542: -- ***************************************************************************************

Line 631: FND_MSG_PUB.initialize;

627: csd_gen_utility_pvt.add('p_txn_billing_type_id ='||p_txn_billing_type_id);
628:
629: /*Initialize message list if p_init_msg_list is set to TRUE.*/
630: IF FND_API.to_Boolean(p_init_msg_list) THEN
631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: /*Initialize API return status to success*/
635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 673: FND_MSG_PUB.Add;

669: EXCEPTION
670: When NO_DATA_FOUND then
671: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
672: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
673: FND_MSG_PUB.Add;
674: RAISE FND_API.G_EXC_ERROR;
675: End;
676:
677: csd_gen_utility_pvt.add('Item billing type is ='||l_billing_type);

Line 699: FND_MSG_PUB.Add;

695: When No_data_found then
696: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
697: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
698: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
699: FND_MSG_PUB.Add;
700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
702: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
703: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 704: FND_MSG_PUB.Add;

700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
702: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
703: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: end;
707: END IF; /*end if l_transaction_type_id */
708:

Line 721: FND_MSG_PUB.Add;

717: If l_txn_billing_type_id is not null then
718: x_txn_billing_type_id:= l_txn_billing_type_id;
719: else
720: FND_MESSAGE.SET_NAME('CSD','CSD_INV_SERVICE_BILLING_TYPE');
721: FND_MSG_PUB.Add;
722: RAISE FND_API.G_EXC_ERROR;
723: end if;
724:
725: Exception

Line 728: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

724:
725: Exception
726: WHEN FND_API.G_EXC_ERROR THEN
727: x_return_status := FND_API.G_RET_STS_ERROR ;
728: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
729: p_data => x_msg_data);
730: when others then
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 732: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

728: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
729: p_data => x_msg_data);
730: when others then
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
733: p_data => x_msg_data);
734: end csd_get_txn_billing_type;
735:
736:

Line 988: FND_MSG_PUB.ADD;

984:
985: IF repair_line_dtls%notfound then
986: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
987: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
988: FND_MSG_PUB.ADD;
989: IF (g_debug > 0 ) THEN
990: csd_gen_utility_pvt.ADD('repair line Id does not exist');
991: END IF;
992:

Line 1014: FND_MSG_PUB.ADD;

1010:
1011: IF cur_contract_det%notfound then
1012: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1013: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
1018: IF cur_contract_det%isopen then

Line 3843: FND_MSG_PUB.Add;

3839: EXCEPTION
3840: When NO_DATA_FOUND then
3841: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3842: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3843: FND_MSG_PUB.Add;
3844: RETURN FALSE;
3845: END Validate_rep_line_id;
3846:
3847: FUNCTION validate_estimate_id

Line 3868: FND_MSG_PUB.Add;

3864: EXCEPTION
3865: When NO_DATA_FOUND then
3866: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3867: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3868: FND_MSG_PUB.Add;
3869: RETURN FALSE;
3870: END Validate_estimate_id;
3871:
3872: FUNCTION validate_estimate_line_id

Line 3893: FND_MSG_PUB.Add;

3889: EXCEPTION
3890: When NO_DATA_FOUND then
3891: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3892: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3893: FND_MSG_PUB.Add;
3894: RETURN FALSE;
3895: END Validate_estimate_line_id;
3896:
3897: FUNCTION Validate_action_type

Line 3913: FND_MSG_PUB.Add;

3909: EXCEPTION
3910: When NO_DATA_FOUND then
3911: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3912: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3913: FND_MSG_PUB.Add;
3914: RETURN FALSE;
3915: END Validate_action_type;
3916:
3917:

Line 3934: FND_MSG_PUB.Add;

3930: EXCEPTION
3931: When NO_DATA_FOUND then
3932: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3933: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3934: FND_MSG_PUB.Add;
3935: RETURN FALSE;
3936: END Validate_action_code;
3937:
3938: --Sangita changes - shirkol

Line 3972: FND_MSG_PUB.Add;

3968: EXCEPTION
3969: When NO_DATA_FOUND then
3970: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3971: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3972: FND_MSG_PUB.Add;
3973: RETURN -1;
3974: END get_org_id;
3975: */
3976:

Line 4023: FND_MSG_PUB.Add;

4019: EXCEPTION
4020: When NO_DATA_FOUND then
4021:
4022: FND_MESSAGE.SET_NAME('CSD','CSD_INVALID_INCIDENT_ID');
4023: FND_MSG_PUB.Add;
4024: RETURN -1;
4025: END get_org_id;
4026:
4027:

Line 4142: FND_MSG_PUB.Add;

4138: EXCEPTION
4139: When NO_DATA_FOUND then
4140: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
4141: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4142: FND_MSG_PUB.Add;
4143: RETURN -1;
4144: END get_bus_process;
4145:
4146: PROCEDURE Convert_to_Chg_rec

Line 4331: FND_MSG_PUB.Add;

4327: EXCEPTION
4328: When NO_DATA_FOUND then
4329: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4330: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4331: FND_MSG_PUB.Add;
4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4335: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 4336: FND_MSG_PUB.Add;

4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4335: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4336: FND_MSG_PUB.Add;
4337: x_return_status := FND_API.G_RET_STS_ERROR ;
4338: END get_line_type;
4339:
4340:

Line 4383: FND_MSG_PUB.Add;

4379: EXCEPTION
4380: When NO_DATA_FOUND then
4381: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4382: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4383: FND_MSG_PUB.Add;
4384: RETURN FALSE;
4385: END Validate_prod_txn_id;
4386:
4387: PROCEDURE Validate_wip_task

Line 4450: FND_MSG_PUB.ADD;

4446: EXCEPTION
4447: WHEN NO_DATA_FOUND THEN
4448: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4449: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4450: FND_MSG_PUB.ADD;
4451: RAISE FND_API.G_EXC_ERROR;
4452: END;
4453: /*
4454: END IF;

Line 4500: FND_MSG_PUB.ADD;

4496: /************* travi comment on 030703 for Bug # 2830828 **************
4497: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4498: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4499: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4500: FND_MSG_PUB.ADD;
4501: IF (g_debug > 0 ) THEN
4502: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);
4503: END IF;
4504:

Line 4525: FND_MSG_PUB.ADD;

4521:
4522: IF l_count > 0 then
4523: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4525: FND_MSG_PUB.ADD;
4526:
4527: IF (g_debug > 0 ) THEN
4528: csd_gen_utility_pvt.ADD('One or more of the tasks for repair line : '||l_repair_line_id||' :is not completed');
4529: END IF;

Line 4610: FND_MSG_PUB.ADD;

4606:
4607: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4608: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4609: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4610: FND_MSG_PUB.ADD;
4611: IF (g_debug > 0 ) THEN
4612: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);
4613: END IF;
4614:

Line 4656: FND_MSG_PUB.Add;

4652: EXCEPTION
4653: When NO_DATA_FOUND then
4654: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4655: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4656: FND_MSG_PUB.Add;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END Is_item_serialized;
4659:
4660: FUNCTION g_miss_num RETURN number

Line 4686: fnd_msg_pub.add_exc_msg(

4682: RETURN fnd_api.g_valid_level_none;
4683: ELSIF p_level = 'FULL' then
4684: RETURN fnd_api.g_valid_level_full;
4685: ELSE
4686: fnd_msg_pub.add_exc_msg(
4687: p_pkg_name => G_PKG_NAME ,
4688: p_procedure_name => 'G_VALID_LEVEL',
4689: p_error_text => 'Unrecognized Value: '||p_level);
4690:

Line 4703: fnd_msg_pub.add_exc_msg(

4699: return FND_API.G_TRUE ;
4700: elsif p_flag = 'FALSE' then
4701: return FND_API.G_FALSE ;
4702: else
4703: fnd_msg_pub.add_exc_msg(
4704: p_pkg_name => G_PKG_NAME,
4705: p_procedure_name => 'G_BOOLEAN',
4706: p_error_text => 'Unrecognized Value: '||p_flag);
4707: RAISE fnd_api.g_exc_unexpected_error;

Line 5097: FND_MSG_PUB.initialize;

5093: END IF;
5094:
5095: -- Initialize message list if p_init_msg_list is set to TRUE.
5096: IF FND_API.to_Boolean(p_init_msg_list) THEN
5097: FND_MSG_PUB.initialize;
5098: END IF;
5099:
5100: -- Initialize API return status to success
5101: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5158: FND_MSG_PUB.Add;

5154:
5155: WHEN others THEN
5156: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5157: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
5158: FND_MSG_PUB.Add;
5159: RAISE FND_API.G_EXC_ERROR;
5160:
5161: END;
5162:

Line 5193: FND_MSG_PUB.Add;

5189:
5190: WHEN no_data_found THEN
5191: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5192: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5193: FND_MSG_PUB.Add;
5194: RAISE FND_API.G_EXC_ERROR;
5195:
5196: WHEN too_many_rows THEN
5197: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

Line 5199: FND_MSG_PUB.Add;

5195:
5196: WHEN too_many_rows THEN
5197: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5198: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5199: FND_MSG_PUB.Add;
5200: RAISE FND_API.G_EXC_ERROR;
5201:
5202: WHEN others THEN
5203: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

Line 5205: FND_MSG_PUB.Add;

5201:
5202: WHEN others THEN
5203: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5204: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5205: FND_MSG_PUB.Add;
5206: RAISE FND_API.G_EXC_ERROR;
5207:
5208: END;
5209:

Line 5415: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

5411:
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5414: x_return_status := FND_API.G_RET_STS_ERROR ;
5415: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5416: p_data => x_msg_data);
5417:
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;

Line 5421: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

5417:
5418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5419: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5421: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5422: p_data => x_msg_data );
5423:
5424: WHEN OTHERS THEN
5425: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;

Line 5427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5423:
5424: WHEN OTHERS THEN
5425: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5428: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5429: l_api_name );
5430: END IF;
5431: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 5428: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

5424: WHEN OTHERS THEN
5425: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5428: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5429: l_api_name );
5430: END IF;
5431: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5432: p_data => x_msg_data );

Line 5431: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

5427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5428: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5429: l_api_name );
5430: END IF;
5431: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5432: p_data => x_msg_data );
5433:
5434:
5435: END GET_RO_DEFAULT_CURR_PL;

Line 5659: FND_MSG_PUB.Count_And_Get

5655: END IF;
5656:
5657:
5658: -- Standard call to get message count and IF count is get message info.
5659: FND_MSG_PUB.Count_And_Get
5660: (p_count => x_msg_count,
5661: p_data => x_msg_data );
5662:
5663: END GET_CHARGE_SELLING_PRICE;

Line 6048: FND_MSG_PUB.Add;

6044: EXCEPTION
6045: WHEN NO_DATA_FOUND THEN
6046: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
6047: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
6048: FND_MSG_PUB.Add;
6049: RAISE FND_API.G_EXC_ERROR;
6050: RETURN NULL;
6051:
6052: WHEN TOO_MANY_ROWS THEN

Line 6054: FND_MSG_PUB.Add;

6050: RETURN NULL;
6051:
6052: WHEN TOO_MANY_ROWS THEN
6053: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
6054: FND_MSG_PUB.Add;
6055: RAISE FND_API.G_EXC_ERROR;
6056: RETURN NULL;
6057:
6058: WHEN OTHERS THEN