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 29: FND_MSG_PUB.Add;

25: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
26: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
27: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
28: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
29: FND_MSG_PUB.Add;
30: RAISE FND_API.G_EXC_ERROR;
31: END IF;
32:
33: END Check_Reqd_Param;

Line 48: FND_MSG_PUB.Add;

44: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
45: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51:
52: END Check_Reqd_Param;

Line 67: FND_MSG_PUB.Add;

63: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
64: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
65: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
66: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
67: FND_MSG_PUB.Add;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70:
71: END Check_Reqd_Param;

Line 91: FND_MSG_PUB.Add;

87: Exception
88: When No_data_found then
89: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
90: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
91: FND_MSG_PUB.Add;
92: RAISE FND_API.G_EXC_ERROR;
93: When Others then
94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
95: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 96: FND_MSG_PUB.Add;

92: RAISE FND_API.G_EXC_ERROR;
93: When Others then
94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
95: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_ERROR;
98: End;
99: END Get_No_Chg_Flag;
100:

Line 116: FND_MSG_PUB.Add;

112: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
113: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
114: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
115: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
116: FND_MSG_PUB.Add;
117: RETURN FALSE;
118: ELSE
119: RETURN TRUE;
120: END IF;

Line 127: FND_MSG_PUB.Add;

123: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
124: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
125: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
126: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
127: FND_MSG_PUB.Add;
128: RETURN FALSE;
129: ELSE
130: RETURN TRUE;
131: END IF;

Line 161: FND_MSG_PUB.Add;

157: EXCEPTION
158: When NO_DATA_FOUND then
159: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
160: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
161: FND_MSG_PUB.Add;
162: RETURN FALSE;
163: END Validate_incident_id;
164:
165: FUNCTION Validate_repair_type_id

Line 187: FND_MSG_PUB.Add;

183: EXCEPTION
184: When NO_DATA_FOUND then
185: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
186: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
187: FND_MSG_PUB.Add;
188: RETURN FALSE;
189: END Validate_repair_type_id;
190:
191: FUNCTION Validate_wip_entity_id

Line 211: FND_MSG_PUB.Add;

207: EXCEPTION
208: When NO_DATA_FOUND then
209: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
210: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
211: FND_MSG_PUB.Add;
212: RETURN FALSE;
213: END Validate_wip_entity_id;
214:
215: FUNCTION Validate_repair_group_id

Line 235: FND_MSG_PUB.Add;

231: EXCEPTION
232: When NO_DATA_FOUND then
233: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
234: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
235: FND_MSG_PUB.Add;
236: RETURN FALSE;
237: END Validate_repair_group_id;
238:
239: FUNCTION Validate_ro_job_date

Line 259: FND_MSG_PUB.Add;

255: EXCEPTION
256: When NO_DATA_FOUND then
257: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
258: FND_MESSAGE.SET_TOKEN('DATE',p_date);
259: FND_MSG_PUB.Add;
260: RETURN FALSE;
261: When TOO_MANY_ROWS then
262: RETURN TRUE;
263: END Validate_ro_job_date;

Line 291: FND_MSG_PUB.Add;

287: EXCEPTION
288: When NO_DATA_FOUND then
289: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
290: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
291: FND_MSG_PUB.Add;
292: RETURN FALSE;
293: END Validate_inventory_item_id;
294:
295: FUNCTION Validate_Unit_of_measure

Line 318: FND_MSG_PUB.Add;

314: EXCEPTION
315: When NO_DATA_FOUND then
316: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
317: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
318: FND_MSG_PUB.Add;
319: END Validate_Unit_of_measure;
320:
321:
322: PROCEDURE Convert_Est_to_Chg_rec

Line 525: FND_MSG_PUB.Add;

521: WHEN NO_DATA_FOUND THEN
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
525: FND_MSG_PUB.Add;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
529: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

Line 530: FND_MSG_PUB.Add;

526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
529: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
530: FND_MSG_PUB.Add;
531: END get_incident_id;
532:
533:
534: -- ***************************************************************************************

Line 623: FND_MSG_PUB.initialize;

619: csd_gen_utility_pvt.add('p_txn_billing_type_id ='||p_txn_billing_type_id);
620:
621: /*Initialize message list if p_init_msg_list is set to TRUE.*/
622: IF FND_API.to_Boolean(p_init_msg_list) THEN
623: FND_MSG_PUB.initialize;
624: END IF;
625:
626: /*Initialize API return status to success*/
627: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 665: FND_MSG_PUB.Add;

661: EXCEPTION
662: When NO_DATA_FOUND then
663: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
664: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: End;
668:
669: csd_gen_utility_pvt.add('Item billing type is ='||l_billing_type);

Line 691: FND_MSG_PUB.Add;

687: When No_data_found then
688: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
689: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
690: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693: When Others then
694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
695: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 696: FND_MSG_PUB.Add;

692: RAISE FND_API.G_EXC_ERROR;
693: When Others then
694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
695: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
696: FND_MSG_PUB.Add;
697: RAISE FND_API.G_EXC_ERROR;
698: end;
699: END IF; /*end if l_transaction_type_id */
700:

Line 713: FND_MSG_PUB.Add;

709: If l_txn_billing_type_id is not null then
710: x_txn_billing_type_id:= l_txn_billing_type_id;
711: else
712: FND_MESSAGE.SET_NAME('CSD','CSD_INV_SERVICE_BILLING_TYPE');
713: FND_MSG_PUB.Add;
714: RAISE FND_API.G_EXC_ERROR;
715: end if;
716:
717: Exception

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

716:
717: Exception
718: WHEN FND_API.G_EXC_ERROR THEN
719: x_return_status := FND_API.G_RET_STS_ERROR ;
720: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
721: p_data => x_msg_data);
722: when others then
723: x_return_status := FND_API.G_RET_STS_ERROR ;
724: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

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

720: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
721: p_data => x_msg_data);
722: when others then
723: x_return_status := FND_API.G_RET_STS_ERROR ;
724: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
725: p_data => x_msg_data);
726: end csd_get_txn_billing_type;
727:
728:

Line 963: FND_MSG_PUB.ADD;

959:
960: IF repair_line_dtls%notfound then
961: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
962: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
963: FND_MSG_PUB.ADD;
964: IF (g_debug > 0 ) THEN
965: csd_gen_utility_pvt.ADD('repair line Id does not exist');
966: END IF;
967:

Line 989: FND_MSG_PUB.ADD;

985:
986: IF cur_contract_det%notfound then
987: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
988: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: IF cur_contract_det%isopen then

Line 3612: FND_MSG_PUB.Add;

3608: EXCEPTION
3609: When NO_DATA_FOUND then
3610: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3611: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3612: FND_MSG_PUB.Add;
3613: RETURN FALSE;
3614: END Validate_rep_line_id;
3615:
3616: FUNCTION validate_estimate_id

Line 3637: FND_MSG_PUB.Add;

3633: EXCEPTION
3634: When NO_DATA_FOUND then
3635: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3636: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3637: FND_MSG_PUB.Add;
3638: RETURN FALSE;
3639: END Validate_estimate_id;
3640:
3641: FUNCTION validate_estimate_line_id

Line 3662: FND_MSG_PUB.Add;

3658: EXCEPTION
3659: When NO_DATA_FOUND then
3660: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3661: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3662: FND_MSG_PUB.Add;
3663: RETURN FALSE;
3664: END Validate_estimate_line_id;
3665:
3666: FUNCTION Validate_action_type

Line 3682: FND_MSG_PUB.Add;

3678: EXCEPTION
3679: When NO_DATA_FOUND then
3680: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3681: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3682: FND_MSG_PUB.Add;
3683: RETURN FALSE;
3684: END Validate_action_type;
3685:
3686:

Line 3703: FND_MSG_PUB.Add;

3699: EXCEPTION
3700: When NO_DATA_FOUND then
3701: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3702: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3703: FND_MSG_PUB.Add;
3704: RETURN FALSE;
3705: END Validate_action_code;
3706:
3707: --Sangita changes - shirkol

Line 3741: FND_MSG_PUB.Add;

3737: EXCEPTION
3738: When NO_DATA_FOUND then
3739: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3740: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3741: FND_MSG_PUB.Add;
3742: RETURN -1;
3743: END get_org_id;
3744: */
3745:

Line 3792: FND_MSG_PUB.Add;

3788: EXCEPTION
3789: When NO_DATA_FOUND then
3790:
3791: FND_MESSAGE.SET_NAME('CSD','CSD_INVALID_INCIDENT_ID');
3792: FND_MSG_PUB.Add;
3793: RETURN -1;
3794: END get_org_id;
3795:
3796:

Line 3911: FND_MSG_PUB.Add;

3907: EXCEPTION
3908: When NO_DATA_FOUND then
3909: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
3910: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3911: FND_MSG_PUB.Add;
3912: RETURN -1;
3913: END get_bus_process;
3914:
3915: PROCEDURE Convert_to_Chg_rec

Line 4073: FND_MSG_PUB.Add;

4069: EXCEPTION
4070: When NO_DATA_FOUND then
4071: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4072: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4073: FND_MSG_PUB.Add;
4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then
4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4077: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

Line 4078: FND_MSG_PUB.Add;

4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then
4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4077: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4078: FND_MSG_PUB.Add;
4079: x_return_status := FND_API.G_RET_STS_ERROR ;
4080: END get_line_type;
4081:
4082:

Line 4125: FND_MSG_PUB.Add;

4121: EXCEPTION
4122: When NO_DATA_FOUND then
4123: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4124: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4125: FND_MSG_PUB.Add;
4126: RETURN FALSE;
4127: END Validate_prod_txn_id;
4128:
4129: PROCEDURE Validate_wip_task

Line 4192: FND_MSG_PUB.ADD;

4188: EXCEPTION
4189: WHEN NO_DATA_FOUND THEN
4190: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4191: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_ERROR;
4194: END;
4195: /*
4196: END IF;

Line 4242: FND_MSG_PUB.ADD;

4238: /************* travi comment on 030703 for Bug # 2830828 **************
4239: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4240: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4241: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4242: FND_MSG_PUB.ADD;
4243: IF (g_debug > 0 ) THEN
4244: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);
4245: END IF;
4246:

Line 4267: FND_MSG_PUB.ADD;

4263:
4264: IF l_count > 0 then
4265: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4266: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4267: FND_MSG_PUB.ADD;
4268:
4269: IF (g_debug > 0 ) THEN
4270: csd_gen_utility_pvt.ADD('One or more of the tasks for repair line : '||l_repair_line_id||' :is not completed');
4271: END IF;

Line 4348: FND_MSG_PUB.ADD;

4344:
4345: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4346: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4347: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4348: FND_MSG_PUB.ADD;
4349: IF (g_debug > 0 ) THEN
4350: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);
4351: END IF;
4352:

Line 4390: FND_MSG_PUB.Add;

4386: EXCEPTION
4387: When NO_DATA_FOUND then
4388: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4389: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4390: FND_MSG_PUB.Add;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END Is_item_serialized;
4393:
4394: FUNCTION g_miss_num RETURN number

Line 4420: fnd_msg_pub.add_exc_msg(

4416: RETURN fnd_api.g_valid_level_none;
4417: ELSIF p_level = 'FULL' then
4418: RETURN fnd_api.g_valid_level_full;
4419: ELSE
4420: fnd_msg_pub.add_exc_msg(
4421: p_pkg_name => G_PKG_NAME ,
4422: p_procedure_name => 'G_VALID_LEVEL',
4423: p_error_text => 'Unrecognized Value: '||p_level);
4424:

Line 4437: fnd_msg_pub.add_exc_msg(

4433: return FND_API.G_TRUE ;
4434: elsif p_flag = 'FALSE' then
4435: return FND_API.G_FALSE ;
4436: else
4437: fnd_msg_pub.add_exc_msg(
4438: p_pkg_name => G_PKG_NAME,
4439: p_procedure_name => 'G_BOOLEAN',
4440: p_error_text => 'Unrecognized Value: '||p_flag);
4441: RAISE fnd_api.g_exc_unexpected_error;

Line 4831: FND_MSG_PUB.initialize;

4827: END IF;
4828:
4829: -- Initialize message list if p_init_msg_list is set to TRUE.
4830: IF FND_API.to_Boolean(p_init_msg_list) THEN
4831: FND_MSG_PUB.initialize;
4832: END IF;
4833:
4834: -- Initialize API return status to success
4835: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4892: FND_MSG_PUB.Add;

4888:
4889: WHEN others THEN
4890: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4891: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
4892: FND_MSG_PUB.Add;
4893: RAISE FND_API.G_EXC_ERROR;
4894:
4895: END;
4896:

Line 4927: FND_MSG_PUB.Add;

4923:
4924: WHEN no_data_found THEN
4925: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4926: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4927: FND_MSG_PUB.Add;
4928: RAISE FND_API.G_EXC_ERROR;
4929:
4930: WHEN too_many_rows THEN
4931: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

Line 4933: FND_MSG_PUB.Add;

4929:
4930: WHEN too_many_rows THEN
4931: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4932: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4933: FND_MSG_PUB.Add;
4934: RAISE FND_API.G_EXC_ERROR;
4935:
4936: WHEN others THEN
4937: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

Line 4939: FND_MSG_PUB.Add;

4935:
4936: WHEN others THEN
4937: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4938: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4939: FND_MSG_PUB.Add;
4940: RAISE FND_API.G_EXC_ERROR;
4941:
4942: END;
4943:

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

5145:
5146: WHEN FND_API.G_EXC_ERROR THEN
5147: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5148: x_return_status := FND_API.G_RET_STS_ERROR ;
5149: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5150: p_data => x_msg_data);
5151:
5152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5153: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;

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

5151:
5152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5153: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5155: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5156: p_data => x_msg_data );
5157:
5158: WHEN OTHERS THEN
5159: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;

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

5157:
5158: WHEN OTHERS THEN
5159: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5163: l_api_name );
5164: END IF;
5165: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 5162: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

5158: WHEN OTHERS THEN
5159: ROLLBACK TO GET_RO_DEFAULT_CURR_PL;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5163: l_api_name );
5164: END IF;
5165: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5166: p_data => x_msg_data );

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

5161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
5163: l_api_name );
5164: END IF;
5165: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
5166: p_data => x_msg_data );
5167:
5168:
5169: END GET_RO_DEFAULT_CURR_PL;

Line 5351: FND_MSG_PUB.Count_And_Get

5347: END IF;
5348:
5349:
5350: -- Standard call to get message count and IF count is get message info.
5351: FND_MSG_PUB.Count_And_Get
5352: (p_count => x_msg_count,
5353: p_data => x_msg_data );
5354:
5355: END GET_CHARGE_SELLING_PRICE;

Line 5706: FND_MSG_PUB.Add;

5702: EXCEPTION
5703: WHEN NO_DATA_FOUND THEN
5704: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
5705: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
5706: FND_MSG_PUB.Add;
5707: RAISE FND_API.G_EXC_ERROR;
5708: RETURN NULL;
5709:
5710: WHEN TOO_MANY_ROWS THEN

Line 5712: FND_MSG_PUB.Add;

5708: RETURN NULL;
5709:
5710: WHEN TOO_MANY_ROWS THEN
5711: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
5712: FND_MSG_PUB.Add;
5713: RAISE FND_API.G_EXC_ERROR;
5714: RETURN NULL;
5715:
5716: WHEN OTHERS THEN