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.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_UTILITY_PVT

Line 45: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

41: WHERE code_combination_id = p_combination_id ;
42:
43: BEGIN
44: IF g_debug THEN
45: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
46: END IF;
47: x_return_status := FND_API.g_ret_sts_success ;
48:
49: OPEN c_get_comb;

Line 54: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Key flex comination Id is invalid' );

50: FETCH c_get_comb INTO l_combination_id ;
51:
52: IF(c_get_comb%NOTFOUND) THEN
53: IF g_debug THEN
54: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Key flex comination Id is invalid' );
55: END IF;
56:
57: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
58: FND_MESSAGE.set_name('OZF', 'The Key flex comination Id is invalid');

Line 72: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

68: EXCEPTION
69: WHEN OTHERS THEN
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71: IF g_debug THEN
72: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
73: END IF;
74:
75: END Validate_GL_KeyFlex_val ;
76:

Line 115: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

111:
112: BEGIN
113:
114: IF g_debug THEN
115: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
116: END IF;
117: x_return_status := FND_API.g_ret_sts_success;
118:
119:

Line 136: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Org Id is null' );

132: p_supp_trade_profile_rec.org_id = FND_API.g_miss_num)) THEN
133:
134:
135: IF g_debug THEN
136: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Org Id is null' );
137: END IF;
138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
139: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_ORG_ID');
140: FND_MSG_PUB.add;

Line 152: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Org Id is not valid' );

148: WHERE organization_id=p_supp_trade_profile_rec.org_id ;
149:
150: IF ( l_org_count = 0 ) THEN
151: IF g_debug THEN
152: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The Org Id is not valid' );
153: END IF;
154:
155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
156: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_ORG_ID');

Line 179: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Claim Communication Channel' );

175:
176: IF l_comn_chan_count=0 THEN
177:
178: IF g_debug THEN
179: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Claim Communication Channel' );
180: END IF;
181:
182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
183: FND_MESSAGE.set_name('OZF', 'Invalid Approval Communication channel'); -- Select Valid Approval Communication Channel

Line 197: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid approval Communication Channel' );

193: AND
194: (p_supp_trade_profile_rec.approval_communication IS NULL OR p_supp_trade_profile_rec.approval_communication = FND_API.g_miss_char) ) THEN
195:
196: IF g_debug THEN
197: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid approval Communication Channel' );
198: END IF;
199:
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
201: FND_MESSAGE.set_name('OZF', 'OZF_APPR_COMM_VALIDATION');

Line 220: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid request Communication Channel' );

216:
217: IF l_comn_chan_count=0 THEN
218:
219: IF g_debug THEN
220: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid request Communication Channel' );
221: END IF;
222:
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
224: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_REQ_COMM_CHAN'); -- Select Valed Request Communication Channel

Line 244: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim Communication Channel' );

240:
241: IF l_comn_chan_count=0 THEN
242:
243: IF g_debug THEN
244: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim Communication Channel' );
245: END IF;
246: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
247: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CLM_COMM_CHAN'); -- Select Valid Claim Communication channel
248: FND_MSG_PUB.add;

Line 260: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim Communication + autodebit combination' );

256: AND
257: (p_supp_trade_profile_rec.claim_communication <>FND_API.g_miss_char AND p_supp_trade_profile_rec.claim_communication IS NOT NULL) ) THEN
258:
259: IF g_debug THEN
260: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim Communication + autodebit combination' );
261: END IF;
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
263: FND_MESSAGE.set_name('OZF', 'OZF_AUTO_DEBIT_VALIDATION');
264: FND_MSG_PUB.add;

Line 289: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method INC is invalid' );

285:
286: IF ( l_sett_inc_count=0 ) THEN
287:
288: IF g_debug THEN
289: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method INC is invalid' );
290: END IF;
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
292: FND_MESSAGE.set_name('OZF', 'OZF_DEF_SET_METH_INC'); -- Select valid value for Default Settlement for Supplier Price Increase Claims
293: FND_MSG_PUB.add;

Line 317: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method DEC is invalid' );

313:
314: IF ( l_sett_dec_count = 0 ) THEN
315:
316: IF g_debug THEN
317: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method DEC is invalid' );
318: END IF;
319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
320: FND_MESSAGE.set_name('OZF', 'OZF_DEF_SET_METH_DEC'); --Select valid value for Default Settlement for Supplier Price Decrease Claims
321: FND_MSG_PUB.add;

Line 344: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method Customer is invalid' );

340:
341: IF ( l_cust_sett_count = 0 ) THEN
342:
343: IF g_debug THEN
344: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Settelemnt method Customer is invalid' );
345: END IF;
346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
347:
348: FND_MESSAGE.set_name('OZF', 'OZF_DEF_SET_METH_CUST'); -- Select Valid value for Default Settlement for Customer Claims

Line 367: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid default days covered' );

363: p_supp_trade_profile_rec.default_days_covered NOT BETWEEN 0 AND 9999
364: ) THEN
365:
366: IF g_debug THEN
367: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid default days covered' );
368: END IF;
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
370:
371: FND_MESSAGE.set_name('OZF', 'OZF_DEFAULT_DAYS_INVALID_VAL');

Line 387: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid authorization period' );

383: p_supp_trade_profile_rec.authorization_period NOT BETWEEN 0 AND 9999
384: ) THEN
385:
386: IF g_debug THEN
387: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid authorization period' );
388: END IF;
389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
390: FND_MESSAGE.set_name('OZF', 'OZF_AUTH_PERIOD_INVALID_VAL');
391: FND_MSG_PUB.add;

Line 406: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid grace days' );

402: p_supp_trade_profile_rec.grace_days NOT BETWEEN 0 AND 9999
403: ) THEN
404:
405: IF g_debug THEN
406: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid grace days' );
407: END IF;
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
409: FND_MESSAGE.set_name('OZF', 'OZF_GRACE_DAYS_INVALID_VAL');
410: FND_MSG_PUB.add;

Line 424: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for increase tolerance' );

420: p_supp_trade_profile_rec.qty_increase_tolerance NOT BETWEEN 0 AND 99
421: ) THEN
422:
423: IF g_debug THEN
424: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for increase tolerance' );
425: END IF;
426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
427:
428: FND_MESSAGE.set_name('OZF', 'OZF_QTY_INC_TOLERANCE_INVALID');

Line 446: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The claim frequency and unit should be provided together' );

442: (NVL(p_supp_trade_profile_rec.claim_frequency,FND_API.g_miss_num) <> FND_API.g_miss_num AND
443: NVL(p_supp_trade_profile_rec.claim_frequency_unit,FND_API.g_miss_char) = FND_API.g_miss_char)) THEN
444:
445: IF g_debug THEN
446: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' The claim frequency and unit should be provided together' );
447: END IF;
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('OZF', 'The claim frequency and unit should be provided together');
450: FND_MSG_PUB.add;

Line 468: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim frequency' );

464:
465: IF (p_supp_trade_profile_rec.claim_frequency < 0) THEN
466:
467: IF g_debug THEN
468: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim frequency' );
469: END IF;
470:
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_FREQ_NEG');

Line 486: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim frequency Unit' );

482:
483: IF ( l_freq_unit_count=0 ) THEN
484:
485: IF g_debug THEN
486: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim frequency Unit' );
487: END IF;
488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
489: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CLM_FREQ_UNIT'); -- Invalid Claim Frequency Unit
490: FND_MSG_PUB.add;

Line 509: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim computation baisis' );

505: AND formula.price_formula_id = p_supp_trade_profile_rec.claim_computation_basis ;
506:
507: IF (l_comp_baisis_count = 0 ) THEN
508: IF g_debug THEN
509: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid value for claim computation baisis' );
510: END IF;
511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
512: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CLM_COMP_BASIS'); -- Invalid Claim Computation Baisis
513: FND_MSG_PUB.add;

Line 533: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid GL Contra Laibility' );

529: x_msg_data => x_msg_data ) ;
530:
531: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
532: IF g_debug THEN
533: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid GL Contra Laibility' );
534: END IF;
535: RAISE FND_API.G_EXC_ERROR ;
536: END IF ;
537:

Line 552: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid GL Cost Adjustment' );

548: x_msg_data => x_msg_data ) ;
549:
550: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
551: IF g_debug THEN
552: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid GL Cost Adjustment' );
553: END IF;
554: RAISE FND_API.G_EXC_ERROR ;
555: END IF ;
556:

Line 560: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );

556:
557: END IF ;
558:
559: IF g_debug THEN
560: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );
561: END IF;
562:
563:
564: EXCEPTION

Line 573: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572: IF g_debug THEN
573: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
574: END IF;
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 584: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

580: p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583: IF g_debug THEN
584: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
585: END IF;
586:
587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 599: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

595: p_count => x_msg_count,
596: p_data => x_msg_data
597: );
598: IF g_debug THEN
599: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
600: END IF;
601:
602:
603: END Validate_Supp_Trade_Profile ;

Line 680: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

676:
677: BEGIN
678:
679: IF g_debug THEN
680: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
681: END IF;
682:
683: x_return_status := FND_API.g_ret_sts_success ;
684:

Line 691: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim conversion type' );

687: OR p_code_conv_rec.CODE_CONVERSION_TYPE = FND_API.g_miss_char
688: OR p_code_conv_rec.CODE_CONVERSION_TYPE<>'OZF_PRODUCT_CODES' ) THEN
689:
690: IF g_debug THEN
691: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid claim conversion type' );
692: END IF;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
694: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CONTYPE_MISSING');
695: FND_MSG_PUB.add;

Line 713: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid internal code' );

709:
710: IF (csr_get_item%NOTFOUND) THEN
711:
712: IF g_debug THEN
713: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid internal code' );
714: END IF;
715: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
716: FND_MESSAGE.set_name('CSS', 'CSS_DEF_INVALID_PRODUCT');
717: FND_MSG_PUB.add;

Line 733: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid External code' );

729: IF p_code_conv_rec.external_code = FND_API.g_miss_char OR
730: p_code_conv_rec.external_code IS NULL THEN
731:
732: IF g_debug THEN
733: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid External code' );
734: END IF;
735: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
736: FND_MESSAGE.set_name('OZF', 'OZF_EXTERNAL_CODE_MISSING'||NVL(p_code_conv_rec.external_code,'NULL'));
737: FND_MSG_PUB.add;

Line 759: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Duplicate code conversion' );

755:
756: IF (l_dummy > 0) THEN
757:
758: IF g_debug THEN
759: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Duplicate code conversion' );
760: END IF;
761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
762: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONVERSION_DUPLICATE');
763: FND_MSG_PUB.add;

Line 777: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid start date' );

773: IF NVL(p_code_conv_rec.start_date_active,TRUNC(SYSDATE)) < TRUNC(SYSDATE)
774: THEN
775:
776: IF g_debug THEN
777: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid start date' );
778: END IF;
779:
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
781: FND_MESSAGE.set_name('OZF', 'OZF_CODE_CONV_STDATE_BKDATED');

Line 789: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' End' );

785: RETURN ;
786: END IF;
787:
788: IF g_debug THEN
789: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' End' );
790: END IF;
791:
792: EXCEPTION
793:

Line 797: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

793:
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF g_debug THEN
797: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
798: END IF;
799:
800:
801: END Validate_Code_Cov_rec ;

Line 870: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

866:
867: x_return_status := FND_API.g_ret_sts_success ;
868:
869: IF g_debug THEN
870: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
871: END IF;
872:
873:
874: OPEN c_pop_rec ;

Line 909: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' No data found for cursor' );

905: p_code_con_rec.attribute15 ;
906: IF ( c_pop_rec%NOTFOUND) THEN
907:
908: IF g_debug THEN
909: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' No data found for cursor' );
910: END IF;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
912: ELSE
913: x_return_status := FND_API.g_ret_sts_success ;

Line 924: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

920:
921: WHEN OTHERS THEN
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: IF g_debug THEN
924: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
925: END IF;
926:
927:
928:

Line 961: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

957: l_supp_trade_profile_rec OZF_SUPP_TRADE_PROFILE_PVT.supp_trade_profile_rec_type ;
958: BEGIN
959:
960: IF g_debug THEN
961: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
962: END IF;
963:
964:
965: IF (p_action = 'U') THEN

Line 1507: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );

1503:
1504: x_supp_trade_profile_rec := l_supp_trade_profile_rec ;
1505:
1506: IF g_debug THEN
1507: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );
1508: END IF;
1509:
1510:
1511: EXCEPTION

Line 1524: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

1520: p_count => x_msg_count,
1521: p_data => x_msg_data
1522: );
1523: IF g_debug THEN
1524: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
1525: END IF;
1526:
1527:
1528:

Line 1636: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );

1632:
1633: BEGIN
1634:
1635: IF g_debug THEN
1636: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts' );
1637: END IF;
1638:
1639: OPEN c_trd_prfl ;
1640: FETCH c_trd_prfl INTO l_ref_supp_trade_profile_rec;

Line 1643: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid trade profile Id' );

1639: OPEN c_trd_prfl ;
1640: FETCH c_trd_prfl INTO l_ref_supp_trade_profile_rec;
1641: IF ( c_trd_prfl%NOTFOUND) THEN
1642: IF g_debug THEN
1643: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid trade profile Id' );
1644: END IF;
1645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1646: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_TRD_PRF_ID');
1647: FND_MSG_PUB.add;

Line 1731: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );

1727: -- Fix for Bug 10056887
1728: p_supp_trade_profile_rec.supplier_neg_batch_flag := p_supp_trade_profile_rec.supplier_neg_batch_flag;
1729: p_supp_trade_profile_rec.ssd_imd_claim_flag := p_supp_trade_profile_rec.ssd_imd_claim_flag;
1730: IF g_debug THEN
1731: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends' );
1732: END IF;
1733:
1734:
1735: EXCEPTION

Line 1740: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

1736:
1737: WHEN OTHERS THEN
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: IF g_debug THEN
1740: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
1741: END IF;
1742:
1743: END Populate_Supp_Trade_Profile ;
1744:

Line 1843: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Starts');

1839: BEGIN
1840:
1841:
1842: IF g_debug THEN
1843: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Starts');
1844: END IF;
1845:
1846:
1847:

Line 1856: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'In compatible call');

1852: G_PKG_NAME)
1853: THEN
1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1855: IF g_debug THEN
1856: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'In compatible call');
1857: END IF;
1858: END IF;
1859:
1860: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1928: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Data initialized');

1924: l_supp_trade_profile_rec.ssd_imd_claim_flag := 'N';
1925: END IF ;
1926:
1927: IF g_debug THEN
1928: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Data initialized');
1929: END IF;
1930:
1931: -------------------------------------------------
1932: -- End : Defaulting data

Line 1972: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Invalid Supplier Site Id');

1968: l_supp_site_count IS NULL
1969: ) THEN
1970:
1971: IF g_debug THEN
1972: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Invalid Supplier Site Id');
1973: END IF;
1974:
1975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1976: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_SUPP_SITE_ID');

Line 1994: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Record for supplier+supplier site already exixts');

1990:
1991: IF ( l_supp_site_comb_count<>0 ) THEN
1992:
1993: IF g_debug THEN
1994: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Record for supplier+supplier site already exixts');
1995: END IF;
1996:
1997: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1998: FND_MESSAGE.set_name('OZF', 'OZF_SUPP_TRADE_PROFILE_DUPLIC');

Line 2019: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid customer');

2015: FETCH c_get_cust_dtl INTO l_ref_cust_dtl_rec;
2016: IF ( c_get_cust_dtl%NOTFOUND) THEN
2017:
2018: IF g_debug THEN
2019: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid customer');
2020: END IF;
2021:
2022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2023: FND_MESSAGE.set_name('OZF', 'OZF_SELECT_CUSTOMER_NAME');

Line 2037: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid customer');

2033: CLOSE c_get_cust_dtl ;
2034:
2035: ELSE
2036: IF g_debug THEN
2037: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid customer');
2038: END IF;
2039:
2040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2041: FND_MESSAGE.set_name('OZF', 'OZF_SELECT_CUSTOMER_NAME');

Line 2066: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validation failed');

2062:
2063: IF x_return_status = FND_API.g_ret_sts_error THEN
2064:
2065: IF g_debug THEN
2066: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validation failed');
2067: END IF;
2068:
2069: RAISE FND_API.G_EXC_ERROR;
2070: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2072: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validation failed');

2068:
2069: RAISE FND_API.G_EXC_ERROR;
2070: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2071: IF g_debug THEN
2072: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validation failed');
2073: END IF;
2074:
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;

Line 2104: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Conversion failed');

2100:
2101: IF x_return_status = FND_API.g_ret_sts_error THEN
2102:
2103: IF g_debug THEN
2104: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Conversion failed');
2105: END IF;
2106:
2107: RAISE FND_API.G_EXC_ERROR;
2108: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2111: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Conversion failed');

2107: RAISE FND_API.G_EXC_ERROR;
2108: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2109:
2110: IF g_debug THEN
2111: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Conversion failed');
2112: END IF;
2113:
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;

Line 2139: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API call failed');

2135:
2136: IF x_return_status = FND_API.g_ret_sts_error THEN
2137:
2138: IF g_debug THEN
2139: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API call failed');
2140: END IF;
2141:
2142: RAISE FND_API.G_EXC_ERROR;
2143:

Line 2147: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API call failed');

2143:
2144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2145:
2146: IF g_debug THEN
2147: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API call failed');
2148: END IF;
2149:
2150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2151:

Line 2156: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API Successful');

2152: ELSE
2153: IF (p_commit = FND_API.G_TRUE) THEN
2154:
2155: IF g_debug THEN
2156: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private API Successful');
2157: END IF;
2158:
2159: IF(p_commit = FND_API.G_TRUE) THEN
2160: COMMIT ;

Line 2183: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling process code conversion');

2179:
2180: END LOOP ;
2181:
2182: IF g_debug THEN
2183: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling process code conversion');
2184: END IF;
2185:
2186: Process_code_conversion(
2187: P_Api_Version_Number => p_api_version_number,

Line 2211: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling process price protection');

2207: -------------------------------------------------
2208:
2209: IF(p_price_protection_set_tbl IS NOT NULL ) THEN
2210: IF g_debug THEN
2211: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling process price protection');
2212: END IF;
2213:
2214: Process_price_protection( P_Api_Version_Number => p_api_version_number,
2215: P_Init_Msg_List => p_init_msg_list,

Line 2240: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');

2236: x_return_status := FND_API.G_RET_STS_ERROR;
2237: END IF ;
2238:
2239: IF g_debug THEN
2240: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');
2241: END IF;
2242:
2243:
2244: EXCEPTION

Line 2255: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2251: p_data => x_msg_data
2252: );
2253:
2254: IF g_debug THEN
2255: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2256: END IF;
2257:
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2268: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2264: p_data => x_msg_data
2265: );
2266:
2267: IF g_debug THEN
2268: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2269: END IF;
2270:
2271:
2272: WHEN OTHERS THEN

Line 2286: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2282: p_data => x_msg_data
2283: );
2284:
2285: IF g_debug THEN
2286: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2287: END IF;
2288:
2289: END Create_Supp_Trade_Profile ;
2290:

Line 2336: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');

2332:
2333: BEGIN
2334:
2335: IF g_debug THEN
2336: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');
2337: END IF;
2338:
2339:
2340: -- Standard call to check for call compatibility.

Line 2348: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' In compatible Call');

2344: G_PKG_NAME)
2345: THEN
2346:
2347: IF g_debug THEN
2348: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' In compatible Call');
2349: END IF ;
2350:
2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2352: END IF;

Line 2366: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Update Supplier Trade Profile');

2362: -- Update Supplier trade profile
2363: -------------------------------------------------
2364:
2365: IF g_debug THEN
2366: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Update Supplier Trade Profile');
2367: END IF;
2368: Update_Supp_Trade_Profile(
2369: p_api_version_number => p_api_version_number ,
2370: p_init_msg_list => p_init_msg_list ,

Line 2387: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Process code conversion');

2383: -------------------------------------------------
2384: -- Process code conversion
2385: ------------------------------------------------
2386: IF g_debug THEN
2387: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Process code conversion');
2388: END IF;
2389:
2390: Process_code_conversion(
2391: p_api_version_number => p_api_version_number ,

Line 2410: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Process Price Protection');

2406: -----------------------------------------------
2407: -- Process price protection
2408: -----------------------------------------------
2409: IF g_debug THEN
2410: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling Process Price Protection');
2411: END IF;
2412:
2413: Process_price_protection(
2414: P_Api_Version_Number => p_api_version_number ,

Line 2430: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');

2426: l_exec_error := 'Y' ;
2427: END IF ;
2428:
2429: IF g_debug THEN
2430: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');
2431: END IF;
2432:
2433: IF (l_exec_error = 'Y') THEN
2434: x_return_status := FND_API.g_ret_sts_error ;

Line 2470: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');

2466:
2467: BEGIN
2468:
2469: IF g_debug THEN
2470: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');
2471: END IF;
2472:
2473: -- Standard call to check for call compatibility.
2474: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2480: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incompatible Call');

2476: l_api_name,
2477: G_PKG_NAME)
2478: THEN
2479: IF g_debug THEN
2480: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incompatible Call');
2481: END IF;
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484:

Line 2500: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' *****The app channel '||l_supp_trade_profile_rec.approval_communication);

2496: x_msg_data => x_msg_data ,
2497: p_supp_trade_profile_rec => l_supp_trade_profile_rec
2498: ) ;
2499:
2500: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' *****The app channel '||l_supp_trade_profile_rec.approval_communication);
2501:
2502:
2503: IF x_return_status = FND_API.g_ret_sts_error THEN
2504: IF g_debug THEN

Line 2505: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate Supplier trade profile failed');

2501:
2502:
2503: IF x_return_status = FND_API.g_ret_sts_error THEN
2504: IF g_debug THEN
2505: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate Supplier trade profile failed');
2506: END IF;
2507: RAISE FND_API.G_EXC_ERROR;
2508: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2509: IF g_debug THEN

Line 2510: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate Supplier trade profile failed');

2506: END IF;
2507: RAISE FND_API.G_EXC_ERROR;
2508: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2509: IF g_debug THEN
2510: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate Supplier trade profile failed');
2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:

Line 2525: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate Supplier trade profile failed');

2521:
2522:
2523: IF x_return_status = FND_API.g_ret_sts_error THEN
2524: IF g_debug THEN
2525: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate Supplier trade profile failed');
2526: END IF;
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2529: IF g_debug THEN

Line 2530: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate Supplier trade profile failed');

2526: END IF;
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2529: IF g_debug THEN
2530: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate Supplier trade profile failed');
2531: END IF;
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: END IF;
2534:

Line 2549: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' *****The app channel '||l_pvt_supp_rec.approval_communication);

2545: p_supp_trade_profile_rec => l_supp_trade_profile_rec,
2546: x_supp_trade_profile_rec => l_pvt_supp_rec ,
2547: p_action => 'U');
2548:
2549: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' *****The app channel '||l_pvt_supp_rec.approval_communication);
2550:
2551: IF x_return_status = FND_API.g_ret_sts_error THEN
2552: IF g_debug THEN
2553: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Convert Supplier trade profile failed');

Line 2553: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Convert Supplier trade profile failed');

2549: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' *****The app channel '||l_pvt_supp_rec.approval_communication);
2550:
2551: IF x_return_status = FND_API.g_ret_sts_error THEN
2552: IF g_debug THEN
2553: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Convert Supplier trade profile failed');
2554: END IF;
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2557: IF g_debug THEN

Line 2558: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Convert Supplier trade profile failed');

2554: END IF;
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2557: IF g_debug THEN
2558: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Convert Supplier trade profile failed');
2559: END IF;
2560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2561: END IF;
2562:

Line 2570: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling private Update profile');

2566: -------------------------------------------------
2567: l_pvt_supp_rec.supp_trade_profile_id := l_supp_trade_profile_rec.supp_trade_profile_id ;
2568:
2569: IF g_debug THEN
2570: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Calling private Update profile');
2571: END IF;
2572:
2573: OZF_SUPP_TRADE_PROFILE_PVT.Update_Supp_Trade_Profile( p_api_version_number => p_api_version_number,
2574: p_init_msg_list => p_init_msg_list,

Line 2584: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private update profile failed');

2580:
2581:
2582: IF x_return_status = FND_API.g_ret_sts_error THEN
2583: IF g_debug THEN
2584: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private update profile failed');
2585: END IF;
2586: RAISE FND_API.G_EXC_ERROR;
2587: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2588: IF g_debug THEN

Line 2589: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private update profile failed');

2585: END IF;
2586: RAISE FND_API.G_EXC_ERROR;
2587: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2588: IF g_debug THEN
2589: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private update profile failed');
2590: END IF;
2591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2592: END IF;
2593:

Line 2599: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');

2595: commit;
2596: END IF ;
2597:
2598: IF g_debug THEN
2599: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Ends');
2600: END IF;
2601:
2602: EXCEPTION
2603: WHEN FND_API.G_EXC_ERROR THEN

Line 2613: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2609: p_data => x_msg_data
2610: );
2611:
2612: IF g_debug THEN
2613: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2614: END IF;
2615:
2616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2625: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2621: p_count => x_msg_count,
2622: p_data => x_msg_data
2623: );
2624: IF g_debug THEN
2625: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2626: END IF;
2627:
2628: WHEN OTHERS THEN
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2642: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);

2638: p_data => x_msg_data
2639: );
2640:
2641: IF g_debug THEN
2642: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm);
2643: END IF;
2644:
2645: END Update_Supp_Trade_Profile ;
2646:

Line 2706: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');

2702:
2703: BEGIN
2704:
2705: IF g_debug THEN
2706: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Starts');
2707: END IF;
2708:
2709: -- Standard call to check for call compatibility.
2710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2716: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incompatible Call');

2712: l_api_name,
2713: G_PKG_NAME)
2714: THEN
2715: IF g_debug THEN
2716: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incompatible Call');
2717: END IF;
2718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2719: END IF;
2720:

Line 2744: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid record');

2740: IF ( csr_supp_rec%NOTFOUND) THEN
2741:
2742: IF g_debug THEN
2743: l_exec_err := 'Y' ;
2744: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid record');
2745: END IF;
2746:
2747: ELSE
2748:

Line 2811: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate code conv returned '||x_return_status );

2807: p_code_conv_rec => l_pvt_code_con_rec,
2808: p_mode => 'C') ;
2809:
2810: IF g_debug THEN
2811: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate code conv returned '||x_return_status );
2812: END IF;
2813: -- Add to create list of the record is valid
2814: IF (x_return_status = FND_API.g_ret_sts_success ) THEN
2815: l_crt_code_conv.extend ;

Line 2823: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' New code conversion Id'||l_pvt_code_con_rec.CODE_CONVERSION_ID );

2819: INTO l_pvt_code_con_rec.CODE_CONVERSION_ID
2820: FROM DUAL;
2821:
2822: IF g_debug THEN
2823: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' New code conversion Id'||l_pvt_code_con_rec.CODE_CONVERSION_ID );
2824: END IF;
2825:
2826: l_crt_code_conv(l_crt_code_conv.COUNT) := l_pvt_code_con_rec;
2827:

Line 2844: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate code conv returned'||x_return_status );

2840: x_msg_data => x_msg_data,
2841: p_code_con_rec => l_pvt_code_con_rec) ;
2842:
2843: IF g_debug THEN
2844: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Populate code conv returned'||x_return_status );
2845: END IF;
2846:
2847:
2848: IF (x_return_status = FND_API.g_ret_sts_success) THEN

Line 2860: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate code conv returned'||x_return_status );

2856: p_code_conv_rec => l_pvt_code_con_rec,
2857: p_mode => 'U') ;
2858:
2859: IF g_debug THEN
2860: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Validate code conv returned'||x_return_status );
2861: END IF;
2862:
2863: -- Add the valid record to update list
2864: IF (x_return_status = FND_API.g_ret_sts_success ) THEN

Line 2979: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Insertion was successful' );

2975:
2976: COMMIT ;
2977: X_created_code_con_tbl := l_crt_code_conv ;
2978: IF g_debug THEN
2979: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Insertion was successful' );
2980: END IF;
2981: END IF ;
2982:
2983:

Line 3030: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Update was successful' );

3026:
3027: COMMIT ;
3028: X_updated_code_con_tbl := l_upd_code_conv ;
3029: IF g_debug THEN
3030: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Update was successful' );
3031: END IF;
3032: END IF ;
3033:
3034: END IF ;

Line 3049: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Delete was successful' );

3045:
3046: COMMIT ;
3047: X_deleted_code_con_tbl := l_del_code_conv ;
3048: IF g_debug THEN
3049: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Mass Delete was successful' );
3050: END IF;
3051: END IF ;
3052:
3053: END IF ;

Line 3061: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' End' );

3057: x_return_status := FND_API.g_ret_sts_error ;
3058: END IF ;
3059:
3060: IF g_debug THEN
3061: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' End' );
3062: END IF;
3063:
3064: EXCEPTION
3065: WHEN FND_API.G_EXC_ERROR THEN

Line 3075: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

3071: p_data => x_msg_data
3072: );
3073:
3074: IF g_debug THEN
3075: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
3076: END IF;
3077:
3078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3079:

Line 3089: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

3085: p_data => x_msg_data
3086: );
3087:
3088: IF g_debug THEN
3089: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
3090: END IF;
3091:
3092: WHEN OTHERS THEN
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3106: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

3102: p_data => x_msg_data
3103: );
3104:
3105: IF g_debug THEN
3106: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
3107: END IF;
3108:
3109:
3110: END Process_code_conversion ;

Line 3200: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Starts' );

3196: BEGIN
3197:
3198:
3199: IF g_debug THEN
3200: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||'Starts' );
3201: END IF;
3202:
3203: -- Standard call to check for call compatibility.
3204: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3210: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incopatible Call' );

3206: l_api_name,
3207: G_PKG_NAME)
3208: THEN
3209: IF g_debug THEN
3210: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Incopatible Call' );
3211: END IF;
3212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3213: END IF;
3214:

Line 3236: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid record' );

3232:
3233: IF ( c_sel_trd_org%NOTFOUND) THEN
3234:
3235: IF g_debug THEN
3236: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid record' );
3237: END IF;
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3239: RETURN ;
3240: ELSE

Line 3291: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Enabled Flag' );

3287:
3288: ELSE
3289: IF(p_process_setup_tbl(indx).ENABLED_FLAG NOT IN ('Y','N')) THEN
3290: IF g_debug THEN
3291: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Enabled Flag' );
3292: END IF;
3293: l_exec_err := 'Y' ;
3294: EXIT api_loop ;
3295:

Line 3314: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Automatic Flag' );

3310:
3311: IF (p_process_setup_tbl(indx).AUTOMATIC_FLAG NOT IN ('Y','N')) THEN
3312:
3313: IF g_debug THEN
3314: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Automatic Flag' );
3315: END IF;
3316: l_exec_err := 'Y' ;
3317: EXIT api_loop ;
3318:

Line 3437: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for update' );

3433: ----------------------------------------------------------------------------------------
3434: -- SET THE DATA FOR UPDATE : END
3435: ----------------------------------------------------------------------------------------
3436: IF g_debug THEN
3437: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for update' );
3438: END IF;
3439: l_process_upd_tbl.extend ;
3440: l_process_upd_tbl(l_process_upd_tbl.COUNT) := l_process_rec ;
3441: l_upd_count := l_upd_count +1 ;

Line 3467: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Enabled Flag' );

3463:
3464: ELSE
3465: IF(p_process_setup_tbl(indx).ENABLED_FLAG NOT IN ('Y','N')) THEN
3466: IF g_debug THEN
3467: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Enabled Flag' );
3468: END IF;
3469: l_exec_err := 'Y' ;
3470: EXIT api_loop ;
3471:

Line 3490: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Automatic Flag' );

3486:
3487: IF (p_process_setup_tbl(indx).AUTOMATIC_FLAG NOT IN ('Y','N')) THEN
3488:
3489: IF g_debug THEN
3490: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Invalid Automatic Flag' );
3491: END IF;
3492: l_exec_err := 'Y' ;
3493: EXIT api_loop ;
3494:

Line 3526: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for create' );

3522: ----------------------------------------------------------------------------------------
3523: -- SET THE DATA FOR CREATE : END
3524: ----------------------------------------------------------------------------------------
3525: IF g_debug THEN
3526: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for create' );
3527: END IF;
3528: l_process_crt_tbl.extend ;
3529: l_process_crt_tbl(l_process_crt_tbl.COUNT) := l_process_rec ;
3530: l_crt_count := l_crt_count +1 ;

Line 3561: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for create' );

3557: ----------------------------------------------------------------------------------------
3558: -- SET THE DATA FOR CREATE : END
3559: ----------------------------------------------------------------------------------------
3560: IF g_debug THEN
3561: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Data for create' );
3562: END IF;
3563: l_process_crt_tbl.extend ;
3564: l_process_crt_tbl(l_process_crt_tbl.COUNT) := l_process_rec ;
3565: l_crt_count := l_crt_count +1 ;

Line 3590: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private create process setup returned'||x_return_status );

3586: x_process_setup_id_tbl => l_crt_id_tbl
3587: ) ;
3588:
3589: IF g_debug THEN
3590: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private create process setup returned'||x_return_status );
3591: END IF;
3592:
3593: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3594:

Line 3620: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private Update process setup returned'||x_return_status );

3616: X_Msg_Data => X_Msg_Data,
3617: P_process_setup_Tbl => l_process_upd_tbl) ;
3618:
3619: IF g_debug THEN
3620: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private Update process setup returned'||x_return_status );
3621: END IF;
3622:
3623: IF g_debug THEN
3624: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Message returned'||X_Msg_Data );

Line 3624: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Message returned'||X_Msg_Data );

3620: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Private Update process setup returned'||x_return_status );
3621: END IF;
3622:
3623: IF g_debug THEN
3624: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||' Message returned'||X_Msg_Data );
3625: END IF;
3626:
3627: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3628: X_updated_process_tbl := l_process_upd_tbl ;

Line 3660: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );

3656: p_count => x_msg_count,
3657: p_data => x_msg_data );
3658:
3659: IF g_debug THEN
3660: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF-STP',G_PKG_NAME||'.'||L_API_NAME||sqlerrm );
3661: END IF;
3662:
3663: END Process_price_protection ;
3664: