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 CSD_GEN_UTILITY_PVT

Line 6: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

2: /* $Header: csdvutlb.pls 120.33.12010000.6 2008/11/10 23:20:57 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvutlb.pls';
6: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
7:
8: /*
9: -- bug fix for 4108369, Begin
10: FUNCTION Get_Sr_add_to_order (

Line 611: csd_gen_utility_pvt.add('At the Begin in ');

607: and cbtc.billing_type = tbt.billing_type
608: and nvl(cbtc.billing_category, '-999') ='M';
609:
610: begin
611: csd_gen_utility_pvt.add('At the Begin in ');
612:
613: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,
614: p_api_name => l_api_name );
615:

Line 613: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,

609:
610: begin
611: csd_gen_utility_pvt.add('At the Begin in ');
612:
613: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,
614: p_api_name => l_api_name );
615:
616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);
617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );

Line 616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);

612:
613: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,
614: p_api_name => l_api_name );
615:
616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);
617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );
618: csd_gen_utility_pvt.add('P_transaction_type_id ='||P_transaction_type_id);
619: csd_gen_utility_pvt.add('p_txn_billing_type_id ='||p_txn_billing_type_id);
620:

Line 617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );

613: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,
614: p_api_name => l_api_name );
615:
616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);
617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );
618: csd_gen_utility_pvt.add('P_transaction_type_id ='||P_transaction_type_id);
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.*/

Line 618: csd_gen_utility_pvt.add('P_transaction_type_id ='||P_transaction_type_id);

614: p_api_name => l_api_name );
615:
616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);
617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );
618: csd_gen_utility_pvt.add('P_transaction_type_id ='||P_transaction_type_id);
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

Line 619: csd_gen_utility_pvt.add('p_txn_billing_type_id ='||p_txn_billing_type_id);

615:
616: csd_gen_utility_pvt.add('P_incident_id ='||P_incident_id);
617: csd_gen_utility_pvt.add('p_inventory_item_id ='||p_inventory_item_id );
618: csd_gen_utility_pvt.add('P_transaction_type_id ='||P_transaction_type_id);
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;

Line 645: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');

641: X_MSG_DATA => x_msg_data,
642: X_ORG_ID => l_operating_unit,
643: X_PROFILE => l_profile);
644: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN
645: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');
646: END IF;
647: ELSE
648: Fnd_Profile.Get('ORG_ID',l_operating_unit);
649: END IF;

Line 651: csd_gen_utility_pvt.add('l_operating_unit ='||l_operating_unit);

647: ELSE
648: Fnd_Profile.Get('ORG_ID',l_operating_unit);
649: END IF;
650:
651: csd_gen_utility_pvt.add('l_operating_unit ='||l_operating_unit);
652:
653: begin
654: select MATERIAL_BILLABLE_FLAG
655: into l_billing_type

Line 669: csd_gen_utility_pvt.add('Item billing type is ='||l_billing_type);

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);
670:
671:
672: l_transaction_type_id:= P_transaction_type_id;
673:

Line 688: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);

684: and nvl(tbt.end_date_active,(sysdate));
685: */
686: exception
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;

Line 920: csd_gen_utility_pvt.add('At the Begin in build_prod_txn_tbl');

916: -- Initialize the table
917: x_prod_txn_tbl.delete;
918:
919: IF (g_debug > 0 ) THEN
920: csd_gen_utility_pvt.add('At the Begin in build_prod_txn_tbl');
921: END IF;
922:
923: IF (g_debug > 0 ) THEN
924: csd_gen_utility_pvt.add('p_repair_line_id ='||p_repair_line_id);

Line 924: csd_gen_utility_pvt.add('p_repair_line_id ='||p_repair_line_id);

920: csd_gen_utility_pvt.add('At the Begin in build_prod_txn_tbl');
921: END IF;
922:
923: IF (g_debug > 0 ) THEN
924: csd_gen_utility_pvt.add('p_repair_line_id ='||p_repair_line_id);
925: END IF;
926:
927:
928: IF NVL(p_repair_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 965: csd_gen_utility_pvt.ADD('repair line Id does not exist');

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:
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;

Line 1000: csd_gen_utility_pvt.add('l_repair_type_ref ='||l_repair_type_ref);

996: END IF;
997:
998:
999: IF (g_debug > 0 ) THEN
1000: csd_gen_utility_pvt.add('l_repair_type_ref ='||l_repair_type_ref);
1001: END IF;
1002:
1003: IF (g_debug > 0 ) THEN
1004: csd_gen_utility_pvt.add('l_auto_process_rma='||l_auto_process_rma);

Line 1004: csd_gen_utility_pvt.add('l_auto_process_rma='||l_auto_process_rma);

1000: csd_gen_utility_pvt.add('l_repair_type_ref ='||l_repair_type_ref);
1001: END IF;
1002:
1003: IF (g_debug > 0 ) THEN
1004: csd_gen_utility_pvt.add('l_auto_process_rma='||l_auto_process_rma);
1005: END IF;
1006:
1007:
1008: -- Get the price_list

Line 1015: csd_gen_utility_pvt.add('l_price list_id ='||l_price_list_id);

1011: -- Get the return reason
1012: l_return_reason := FND_PROFILE.value('CSD_DEF_RMA_RETURN_REASON');
1013:
1014: IF (g_debug > 0 ) THEN
1015: csd_gen_utility_pvt.add('l_price list_id ='||l_price_list_id);
1016: END IF;
1017:
1018: IF (g_debug > 0 ) THEN
1019: csd_gen_utility_pvt.add('l_return_reason ='||l_return_reason);

Line 1019: csd_gen_utility_pvt.add('l_return_reason ='||l_return_reason);

1015: csd_gen_utility_pvt.add('l_price list_id ='||l_price_list_id);
1016: END IF;
1017:
1018: IF (g_debug > 0 ) THEN
1019: csd_gen_utility_pvt.add('l_return_reason ='||l_return_reason);
1020: END IF;
1021:
1022: IF (g_debug > 0 ) THEN
1023: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );

Line 1023: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );

1019: csd_gen_utility_pvt.add('l_return_reason ='||l_return_reason);
1020: END IF;
1021:
1022: IF (g_debug > 0 ) THEN
1023: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1024: END IF;
1025:
1026: IF (g_debug > 0 ) THEN
1027: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );

Line 1027: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );

1023: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1024: END IF;
1025:
1026: IF (g_debug > 0 ) THEN
1027: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1028: END IF;
1029:
1030: IF (g_debug > 0 ) THEN
1031: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );

Line 1031: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );

1027: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1028: END IF;
1029:
1030: IF (g_debug > 0 ) THEN
1031: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1032: END IF;
1033:
1034: IF (g_debug > 0 ) THEN
1035: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );

Line 1035: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );

1031: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1032: END IF;
1033:
1034: IF (g_debug > 0 ) THEN
1035: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1036: END IF;
1037:
1038:
1039: /*Bug#5190905

Line 1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');

1171: end if;
1172: end if;
1173:
1174: IF (g_debug > 0 ) THEN
1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');
1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );

Line 1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );

1172: end if;
1173:
1174: IF (g_debug > 0 ) THEN
1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');
1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1180: END IF;

Line 1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );

1173:
1174: IF (g_debug > 0 ) THEN
1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');
1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1180: END IF;
1181:

Line 1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );

1174: IF (g_debug > 0 ) THEN
1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');
1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1180: END IF;
1181:
1182:

Line 1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );

1175: csd_gen_utility_pvt.add('After calling csd_get_txn_billing_type ');
1176: csd_gen_utility_pvt.add('l_cps_txn_billing_type_id='||l_cps_txn_billing_type_id );
1177: csd_gen_utility_pvt.add('l_cpr_txn_billing_type_id='||l_cpr_txn_billing_type_id );
1178: csd_gen_utility_pvt.add('l_ls_txn_billing_type_id ='||l_ls_txn_billing_type_id );
1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1180: END IF;
1181:
1182:
1183: l_org_id := csd_process_util.get_org_id(l_incident_id);

Line 1190: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);

1186: --l_inv_org_id := csd_process_util.get_inv_org_id;
1187:
1188: IF (g_debug > 0 ) THEN
1189:
1190: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);
1191: csd_gen_utility_pvt.add('l_org_id ='||l_org_id);
1192: csd_gen_utility_pvt.add('l_inv_org_id ='||l_inv_org_id);
1193:
1194: END IF;

Line 1191: csd_gen_utility_pvt.add('l_org_id ='||l_org_id);

1187:
1188: IF (g_debug > 0 ) THEN
1189:
1190: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);
1191: csd_gen_utility_pvt.add('l_org_id ='||l_org_id);
1192: csd_gen_utility_pvt.add('l_inv_org_id ='||l_inv_org_id);
1193:
1194: END IF;
1195:

Line 1192: csd_gen_utility_pvt.add('l_inv_org_id ='||l_inv_org_id);

1188: IF (g_debug > 0 ) THEN
1189:
1190: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);
1191: csd_gen_utility_pvt.add('l_org_id ='||l_org_id);
1192: csd_gen_utility_pvt.add('l_inv_org_id ='||l_inv_org_id);
1193:
1194: END IF;
1195:
1196: l_revision := l_inv_revision;

Line 3775: csd_gen_utility_pvt.add('Error in deriving the Org id ');

3771: x_org_id => l_org_id,
3772: x_profile => l_profile);
3773:
3774: if( l_return_status <> csd_process_util.g_ret_sts_success) then
3775: csd_gen_utility_pvt.add('Error in deriving the Org id ');
3776: end if;
3777:
3778: ELSE
3779: ------------------------------------------------------

Line 4206: csd_gen_utility_pvt.add('l_repair_line_id ='||l_repair_line_id);

4202:
4203: END IF;
4204:
4205: IF (g_debug > 0 ) THEN
4206: csd_gen_utility_pvt.add('l_repair_line_id ='||l_repair_line_id);
4207: END IF;
4208:
4209: IF (g_debug > 0 ) THEN
4210: csd_gen_utility_pvt.add('l_repair_mode ='||l_repair_mode);

Line 4210: csd_gen_utility_pvt.add('l_repair_mode ='||l_repair_mode);

4206: csd_gen_utility_pvt.add('l_repair_line_id ='||l_repair_line_id);
4207: END IF;
4208:
4209: IF (g_debug > 0 ) THEN
4210: csd_gen_utility_pvt.add('l_repair_mode ='||l_repair_mode);
4211: END IF;
4212:
4213:
4214: IF l_repair_mode = 'WIP' then

Line 4225: csd_gen_utility_pvt.add('repair line Id not found');

4221: EXCEPTION
4222: WHEN OTHERS THEN
4223: RAISE FND_API.G_EXC_ERROR;
4224: IF (g_debug > 0 ) THEN
4225: csd_gen_utility_pvt.add('repair line Id not found');
4226: END IF;
4227:
4228: END;
4229:

Line 4231: csd_gen_utility_pvt.add('l_qty_completed ='||l_qty_completed);

4227:
4228: END;
4229:
4230: IF (g_debug > 0 ) THEN
4231: csd_gen_utility_pvt.add('l_qty_completed ='||l_qty_completed);
4232: END IF;
4233:
4234: IF (g_debug > 0 ) THEN
4235: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);

Line 4235: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);

4231: csd_gen_utility_pvt.add('l_qty_completed ='||l_qty_completed);
4232: END IF;
4233:
4234: IF (g_debug > 0 ) THEN
4235: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);
4236: END IF;
4237:
4238: /************* travi comment on 030703 for Bug # 2830828 **************
4239: If nvl(l_qty_completed,0) < l_prod_txn_qty then

Line 4244: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);

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:
4247: RAISE FND_API.G_EXC_ERROR;
4248: end if;

Line 4261: csd_gen_utility_pvt.ADD('l_count= '||l_count);

4257: and source_object_id = l_repair_line_id
4258: and task_status_id not in (7,8,9,11);
4259:
4260: IF (g_debug > 0 ) THEN
4261: csd_gen_utility_pvt.ADD('l_count= '||l_count);
4262: END IF;
4263:
4264: IF l_count > 0 then
4265: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');

Line 4270: csd_gen_utility_pvt.ADD('One or more of the tasks for repair line : '||l_repair_line_id||' :is not completed');

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;
4272: End If;
4273:
4274: END IF;

Line 4333: csd_gen_utility_pvt.add('l_qty_by_type ='||l_qty_by_type);

4329: l_prod_txn_qty := p_prod_txn_qty;
4330: END IF;
4331:
4332: IF (g_debug > 0 ) THEN
4333: csd_gen_utility_pvt.add('l_qty_by_type ='||l_qty_by_type);
4334: END IF;
4335:
4336: IF (g_debug > 0 ) THEN
4337: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);

Line 4337: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);

4333: csd_gen_utility_pvt.add('l_qty_by_type ='||l_qty_by_type);
4334: END IF;
4335:
4336: IF (g_debug > 0 ) THEN
4337: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);
4338: END IF;
4339:
4340: IF (g_debug > 0 ) THEN
4341: csd_gen_utility_pvt.add('l_repair_qty ='||l_repair_qty);

Line 4341: csd_gen_utility_pvt.add('l_repair_qty ='||l_repair_qty);

4337: csd_gen_utility_pvt.add('l_prod_txn_qty ='||l_prod_txn_qty);
4338: END IF;
4339:
4340: IF (g_debug > 0 ) THEN
4341: csd_gen_utility_pvt.add('l_repair_qty ='||l_repair_qty);
4342: END IF;
4343:
4344:
4345: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN

Line 4350: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);

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:
4353: RAISE FND_API.G_EXC_ERROR;
4354: END IF;

Line 4690: csd_gen_utility_pvt.add('p_object_type_code ='||p_object_type_code);

4686:
4687: if(l_code = 'RS_') then
4688: l_object_type_code := p_object_type_code;
4689: IF (g_debug > 0 ) THEN
4690: csd_gen_utility_pvt.add('p_object_type_code ='||p_object_type_code);
4691: END IF;
4692:
4693: else
4694: l_object_type_code := 'RS_'||p_object_type_code;

Line 4696: csd_gen_utility_pvt.add('In else p_object_type_code ='||p_object_type_code);

4692:
4693: else
4694: l_object_type_code := 'RS_'||p_object_type_code;
4695: IF (g_debug > 0 ) THEN
4696: csd_gen_utility_pvt.add('In else p_object_type_code ='||p_object_type_code);
4697: END IF;
4698:
4699: end if;
4700: end if;

Line 4712: csd_gen_utility_pvt.add('No data found for l_object_type_code ='||l_object_type_code);

4708:
4709: IF c_references%NOTFOUND
4710: THEN
4711: IF (g_debug > 0 ) THEN
4712: csd_gen_utility_pvt.add('No data found for l_object_type_code ='||l_object_type_code);
4713: END IF;
4714:
4715: -- NULL;
4716: END IF;

Line 4814: csd_gen_utility_pvt.ADD ('GET_RO_DEFAULT_CURR_PL Begins');

4810: BEGIN
4811:
4812: --debug msg
4813: IF (g_debug > 0 ) THEN
4814: csd_gen_utility_pvt.ADD ('GET_RO_DEFAULT_CURR_PL Begins');
4815: END IF;
4816:
4817: -- Standard Start of API savepoint
4818: SAVEPOINT GET_RO_DEFAULT_CURR_PL;

Line 4842: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,

4838: -- Begin API Body
4839: --
4840:
4841: IF (g_debug > 0 ) THEN
4842: csd_gen_utility_pvt.dump_api_info ( p_pkg_name => G_PKG_NAME,
4843: p_api_name => l_api_name );
4844: END IF;
4845:
4846: --debug msg

Line 4848: csd_gen_utility_pvt.ADD ('Check required parameters and validate them');

4844: END IF;
4845:
4846: --debug msg
4847: IF (g_debug > 0 ) THEN
4848: csd_gen_utility_pvt.ADD ('Check required parameters and validate them');
4849: END IF;
4850:
4851: -- Check the required parameters
4852: CSD_PROCESS_UTIL.Check_Reqd_Param

Line 4871: csd_gen_utility_pvt.ADD ('Check required parameters and validation complete');

4867: END IF;
4868:
4869: --debug msg
4870: IF (g_debug > 0 ) THEN
4871: csd_gen_utility_pvt.ADD ('Check required parameters and validation complete');
4872: END IF;
4873:
4874:
4875: --debug msg

Line 4877: csd_gen_utility_pvt.ADD ('Get business process');

4873:
4874:
4875: --debug msg
4876: IF (g_debug > 0 ) THEN
4877: csd_gen_utility_pvt.ADD ('Get business process');
4878: END IF;
4879:
4880: BEGIN
4881:

Line 4907: csd_gen_utility_pvt.ADD ('Get SR contract');

4903: -- If user did not set default price list, null will be returned
4904:
4905: --debug msg
4906: IF (g_debug > 0 ) THEN
4907: csd_gen_utility_pvt.ADD ('Get SR contract');
4908: END IF;
4909:
4910: -- Incident ID is passed in, get SR contract
4911: IF (p_incident_id IS NOT NULL) THEN

Line 4988: csd_gen_utility_pvt.ADD ('Call OKS_Con_Coverage_PUB.Get_BP_PriceList API: ro contract ='|| p_ro_contract_line_id);

4984: IF (p_ro_contract_line_id IS NOT NULL) THEN
4985:
4986: --debug msg
4987: IF (g_debug > 0 ) THEN
4988: csd_gen_utility_pvt.ADD ('Call OKS_Con_Coverage_PUB.Get_BP_PriceList API: ro contract ='|| p_ro_contract_line_id);
4989: END IF;
4990:
4991: BEGIN
4992:

Line 5009: csd_gen_utility_pvt.ADD ('Call OKS API to get price list: return status ='|| x_return_status);

5005: );
5006:
5007: --debug msg
5008: IF (g_debug > 0 ) THEN
5009: csd_gen_utility_pvt.ADD ('Call OKS API to get price list: return status ='|| x_return_status);
5010: csd_gen_utility_pvt.ADD ('l_pl_out_tbl(i).bp_price_list_id: '|| l_pl_out_tbl(i).bp_price_list_id);
5011: END IF;
5012:
5013: EXCEPTION

Line 5010: csd_gen_utility_pvt.ADD ('l_pl_out_tbl(i).bp_price_list_id: '|| l_pl_out_tbl(i).bp_price_list_id);

5006:
5007: --debug msg
5008: IF (g_debug > 0 ) THEN
5009: csd_gen_utility_pvt.ADD ('Call OKS API to get price list: return status ='|| x_return_status);
5010: csd_gen_utility_pvt.ADD ('l_pl_out_tbl(i).bp_price_list_id: '|| l_pl_out_tbl(i).bp_price_list_id);
5011: END IF;
5012:
5013: EXCEPTION
5014:

Line 5139: csd_gen_utility_pvt.ADD ('GET_RO_DEFAULT_CURR_PL Ends');

5135: -- gilam: end bug 3512619
5136:
5137: --debug msg
5138: IF (g_debug > 0 ) THEN
5139: csd_gen_utility_pvt.ADD ('GET_RO_DEFAULT_CURR_PL Ends');
5140: END IF;
5141:
5142: -- API body ends here
5143:

Line 5317: csd_gen_utility_pvt.ADD('Cs_Pricing_Item_Pkg.Call_Pricing_Item failed');

5313: x_msg_data => x_msg_data);
5314:
5315: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5316: IF (g_debug > 0 ) THEN
5317: csd_gen_utility_pvt.ADD('Cs_Pricing_Item_Pkg.Call_Pricing_Item failed');
5318: END IF;
5319: -- Shiv Ragunathan, 2/26/04, While fixing FP bug 3449351, noticed
5320: -- that this exception gets raised and is not handled in the API,
5321: -- Since the error status is being returned, no need to raise the

Line 5343: csd_gen_utility_pvt.ADD('CSD_PROCESS_UTIL.PRICE_REQUEST failed');

5339: x_msg_data => x_msg_data);
5340:
5341: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5342: IF (g_debug > 0 ) THEN
5343: csd_gen_utility_pvt.ADD('CSD_PROCESS_UTIL.PRICE_REQUEST failed');
5344: END IF;
5345: END IF;
5346:
5347: END IF;

Line 5643: csd_gen_utility_pvt.ADD('QP_PREQ_PUB.PRICE_REQUEST failed');

5639: END IF;
5640:
5641: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5642: IF (g_debug > 0 ) THEN
5643: csd_gen_utility_pvt.ADD('QP_PREQ_PUB.PRICE_REQUEST failed');
5644: END IF;
5645: END IF;
5646:
5647: END PRICE_REQUEST;