APPS.M4U_GLOBAL_REGQRY dependencies on M4U_GLOBAL_REGQRY

Line 1: PACKAGE BODY m4u_global_regqry AS

1: PACKAGE BODY m4u_global_regqry AS
2: /* $Header: M4UQRREB.pls 120.2 2005/07/07 04:14:49 rkrishan noship $ */
3: l_debug_level NUMBER ;
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_global_regqry';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_global_regqry';

1: PACKAGE BODY m4u_global_regqry AS
2: /* $Header: M4UQRREB.pls 120.2 2005/07/07 04:14:49 rkrishan noship $ */
3: l_debug_level NUMBER ;
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_global_regqry';
5:
6:
7:
8:

Line 351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);

347: BEGIN
348:
349: -- Parameters received
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('---- m4u_global_regqry.process_gtin_resp ---- ' ,1);
352: cln_debug_pub.Add('p_gtin - '|| p_gtin ,1);
353: cln_debug_pub.Add('p_data_source - '|| p_data_source ,1);
354: cln_debug_pub.Add('p_target_market - '|| p_target_market ,1);
355: cln_debug_pub.Add('p_src_data_pool - '|| p_src_data_pool ,1);

Line 472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);

468: IF (UPPER(p_success_flag) <> 'TRUE') THEN
469: IF (l_Debug_Level <= 1) THEN
470: cln_debug_pub.Add('-- Error Status :Returning -' ,1);
471: cln_debug_pub.Add('Collaboration Detail ID - '||l_collab_detail_id ,1);
472: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp - Response status as false',2);
473: END IF;
474: RETURN;
475: END IF;
476:

Line 495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);

491: (p_net_wt_uom IS NULL)) THEN
492: IF (l_Debug_Level <= 1) THEN
493: cln_debug_pub.Add('Measurement Values all null. Information requestor different from content owner' ,1);
494: cln_debug_pub.Add('Returning with success...' ,1);
495: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
496: END IF;
497:
498: RETURN;
499: END IF;

Line 540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);

536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: IF (l_Debug_Level <= 2) THEN
540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
541: END IF;
542:
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN

Line 548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);

544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: IF (l_Debug_Level <= 4) THEN
547: cln_debug_pub.Add(x_msg_data,4);
548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);
549: END IF;
550:
551: WHEN OTHERS THEN
552: l_error_code := SQLCODE;

Line 567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);

563: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
564: END IF;
565:
566: IF (l_debug_level <= 2) THEN
567: cln_debug_pub.add('Exiting m4u_global_regqry.process_gtin_resp - exception',2);
568: cln_debug_pub.add('====================================================',2);
569: END IF;
570:
571: END;

Line 575: END m4u_global_regqry;

571: END;
572:
573: BEGIN
574: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
575: END m4u_global_regqry;