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.AMS_ACTPRODUCT_PVT dependencies on AMS_UTILITY_PVT

Line 24: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);

20: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
21: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
22: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
23:
24: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
25: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
26: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
27:
28:

Line 25: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);

21: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
22: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
23:
24: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
25: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
26: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
27:
28:
29: --

Line 26: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);

22: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
23:
24: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
25: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
26: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
27:
28:
29: --
30: -- Procedure and function declarations.

Line 149: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

145: --
146: ----------------------- validate -----------------------
147: IF (AMS_DEBUG_HIGH_ON) THEN
148:
149: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
150: END IF;
151: Validate_Act_Product
152: ( p_api_version => 1.0
153: ,p_init_msg_list => p_init_msg_list

Line 177: AMS_Utility_PVT.debug_message(l_api_name||': check access');

173: -- Changed by rssharma as we will not require this validation for exclusion .. added prod to the list
174: IF l_act_Product_rec.arc_act_product_used_by NOT IN ('MESG','OFFR' , 'PROD') THEN
175: IF (AMS_DEBUG_HIGH_ON) THEN
176:
177: AMS_Utility_PVT.debug_message(l_api_name||': check access');
178: END IF;
179: l_user_id := FND_GLOBAL.User_Id;
180: IF (AMS_DEBUG_HIGH_ON) THEN
181:

Line 182: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);

178: END IF;
179: l_user_id := FND_GLOBAL.User_Id;
180: IF (AMS_DEBUG_HIGH_ON) THEN
181:
182: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);
183: END IF;
184: if l_user_id IS NOT NULL then
185: open get_res_id(l_user_id);
186: fetch get_res_id into l_res_id;

Line 454: AMS_Utility_PVT.debug_message(l_api_name||': check access');

450: --------------- CHECK ACCESS FOR THE USER-------------------
451: ----------added sugupta 07/25/2000
452: IF (AMS_DEBUG_HIGH_ON) THEN
453:
454: AMS_Utility_PVT.debug_message(l_api_name||': check access');
455: END IF;
456: l_user_id := FND_GLOBAL.User_Id;
457: IF (AMS_DEBUG_HIGH_ON) THEN
458:

Line 459: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);

455: END IF;
456: l_user_id := FND_GLOBAL.User_Id;
457: IF (AMS_DEBUG_HIGH_ON) THEN
458:
459: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);
460: END IF;
461: if l_user_id IS NOT NULL then
462: open get_res_id(l_user_id);
463: fetch get_res_id into l_res_id;

Line 666: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);

662: ----------added sugupta 07/25/2000
663: l_user_id := FND_GLOBAL.User_Id;
664: IF (AMS_DEBUG_HIGH_ON) THEN
665:
666: AMS_Utility_PVT.debug_message(l_api_name||': check access- user id='||l_user_id);
667: END IF;
668: if l_user_id IS NOT NULL then
669: open get_res_id(l_user_id);
670: fetch get_res_id into l_res_id;

Line 891: WHEN AMS_Utility_PVT.resource_locked THEN

887: ( p_count => x_msg_count,
888: p_data => x_msg_data,
889: p_encoded => FND_API.G_FALSE
890: );
891: WHEN AMS_Utility_PVT.resource_locked THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
894: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
895: FND_MSG_PUB.add;

Line 966: AMS_Utility_PVT.debug_message(l_full_name||': check items');

962: -- API body
963: --
964: IF (AMS_DEBUG_HIGH_ON) THEN
965:
966: AMS_Utility_PVT.debug_message(l_full_name||': check items');
967: END IF;
968: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
969: THEN
970: Validate_Act_Product_Items

Line 988: AMS_Utility_PVT.debug_message(l_full_name||': check record level');

984: -- Perform cross attribute validation and missing attribute checks. Record
985: -- level validation.
986: IF (AMS_DEBUG_HIGH_ON) THEN
987:
988: AMS_Utility_PVT.debug_message(l_full_name||': check record level');
989: END IF;
990: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
991: THEN
992: Validate_Act_product_Record(

Line 1072: AMS_UTILITY_PVT.debug_message('check_primary_flag: '|| p_act_product_rec.primary_product_flag);

1068: IF (AMS_DEBUG_HIGH_ON) THEN
1069:
1070:
1071:
1072: AMS_UTILITY_PVT.debug_message('check_primary_flag: '|| p_act_product_rec.primary_product_flag);
1073:
1074: END IF;
1075:
1076: IF p_act_product_rec.primary_product_flag <> FND_API.G_MISS_CHAR

Line 1089: AMS_UTILITY_PVT.debug_message('l_primary_flag: '|| l_primary_flag);

1085: IF (AMS_DEBUG_HIGH_ON) THEN
1086:
1087:
1088:
1089: AMS_UTILITY_PVT.debug_message('l_primary_flag: '|| l_primary_flag);
1090:
1091: END IF;
1092:
1093: IF l_primary_flag = 'Y'

Line 1109: AMS_UTILITY_PVT.debug_message('check_primary_flag is checked with no errors');

1105: IF (AMS_DEBUG_HIGH_ON) THEN
1106:
1107:
1108:
1109: AMS_UTILITY_PVT.debug_message('check_primary_flag is checked with no errors');
1110:
1111: END IF;
1112:
1113: END check_primary_flag;

Line 1309: IF AMS_Utility_PVT.check_uniqueness(

1305: -- Validate uniqueness
1306: IF p_validation_mode = JTF_PLSQL_API.g_create
1307: AND p_act_Product_rec.activity_product_id IS NOT NULL
1308: THEN
1309: IF AMS_Utility_PVT.check_uniqueness(
1310: 'ams_act_products',
1311: 'activity_product_id = ' || p_act_Product_rec.activity_product_id
1312: ) = FND_API.g_false
1313: THEN

Line 1327: IF AMS_Utility_PVT.check_lookup_exists(

1323: --
1324: -- check for lookups....ARC_ACT_PRODUCT_USED_BY
1325: --
1326: IF p_act_Product_rec.arc_act_product_used_by <> FND_API.g_miss_char THEN
1327: IF AMS_Utility_PVT.check_lookup_exists(
1328: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1329: p_lookup_code => p_act_Product_rec.arc_act_product_used_by
1330: ) = FND_API.g_false
1331: THEN

Line 1345: IF AMS_Utility_PVT.check_lookup_exists(

1341: --
1342: -- check for lookups....LEVEL_TYPE_CODE
1343: --
1344: IF p_act_Product_rec.LEVEL_TYPE_CODE <> FND_API.g_miss_char THEN
1345: IF AMS_Utility_PVT.check_lookup_exists(
1346: p_lookup_type => 'AMS_PRODUCT_LEVEL',
1347: p_lookup_code => p_act_Product_rec.LEVEL_TYPE_CODE
1348: ) = FND_API.g_false
1349: THEN

Line 1447: IF AMS_Utility_PVT.Check_FK_Exists (

1443: l_pk_name := 'MODEL_ID';
1444: END IF;
1445:
1446: l_pk_value := p_act_Product_rec.act_product_used_by_id;
1447: IF AMS_Utility_PVT.Check_FK_Exists (
1448: p_table_name => l_table_name
1449: ,p_pk_name => l_pk_name
1450: ,p_pk_value => l_pk_value
1451: ) = FND_API.G_FALSE

Line 1469: IF AMS_Utility_PVT.Check_FK_Exists (

1465: THEN
1466: l_table_name := 'MTL_SYSTEM_ITEMS_VL';
1467: l_pk_name := 'inventory_item_id';
1468: l_pk_value := p_act_Product_rec.inventory_item_id;
1469: IF AMS_Utility_PVT.Check_FK_Exists (
1470: p_table_name => l_table_name
1471: ,p_pk_name => l_pk_name
1472: ,p_pk_value => l_pk_value
1473: ) = FND_API.G_FALSE

Line 1492: IF AMS_Utility_PVT.Check_FK_Exists (

1488: THEN
1489: l_table_name := 'MTL_SYSTEM_ITEMS_VL';
1490: l_pk_name := 'organization_id';
1491: l_pk_value := p_act_Product_rec.organization_id;
1492: IF AMS_Utility_PVT.Check_FK_Exists (
1493: p_table_name => l_table_name
1494: ,p_pk_name => l_pk_name
1495: ,p_pk_value => l_pk_value
1496: ) = FND_API.G_FALSE

Line 1514: IF AMS_Utility_PVT.Check_FK_Exists (

1510: THEN
1511: l_table_name := 'MTL_CATEGORIES';
1512: l_pk_name := 'category_id';
1513: l_pk_value := p_act_Product_rec.category_id;
1514: IF AMS_Utility_PVT.Check_FK_Exists (
1515: p_table_name => l_table_name
1516: ,p_pk_name => l_pk_name
1517: ,p_pk_value => l_pk_value
1518: ) = FND_API.G_FALSE

Line 1536: IF AMS_Utility_PVT.Check_FK_Exists (

1532: THEN
1533: l_table_name := 'MTL_CATEGORY_SETS';
1534: l_pk_name := 'category_set_id';
1535: l_pk_value := p_act_Product_rec.category_set_id;
1536: IF AMS_Utility_PVT.Check_FK_Exists (
1537: p_table_name => l_table_name
1538: ,p_pk_name => l_pk_name
1539: ,p_pk_value => l_pk_value
1540: ) = FND_API.G_FALSE

Line 1560: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.enabled_flag) = FND_API.g_false

1556: ----------------------- enabled_flag ------------------------
1557: IF p_act_Product_rec.enabled_flag <> FND_API.g_miss_char
1558: AND p_act_Product_rec.enabled_flag IS NOT NULL
1559: THEN
1560: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.enabled_flag) = FND_API.g_false
1561: THEN
1562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1563: THEN
1564: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_ENABLED_FLAG');

Line 1575: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.excluded_flag) = FND_API.g_false

1571: ----------------------- excluded_flag ------------------------
1572: IF p_act_Product_rec.excluded_flag <> FND_API.g_miss_char
1573: AND p_act_Product_rec.excluded_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.excluded_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_EXCLUDED_FLAG');

Line 1591: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.primary_product_flag) = FND_API.g_false

1587: ----------------------- primary_product_flag ------------------------
1588: IF p_act_Product_rec.primary_product_flag <> FND_API.g_miss_char
1589: AND p_act_Product_rec.primary_product_flag IS NOT NULL
1590: THEN
1591: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.primary_product_flag) = FND_API.g_false
1592: THEN
1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1594: THEN
1595: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_PRIMARY_FLAG');

Line 2417: IF AMS_UTILITY_PVT.logging_enabled (p_log_level)

2413: l_module_name VARCHAR2(400);
2414: DELIMETER CONSTANT VARCHAR2(1) := '.';
2415: LABEL_PREFIX CONSTANT VARCHAR2(15) := 'WFScheduleExec';
2416: BEGIN
2417: IF AMS_UTILITY_PVT.logging_enabled (p_log_level)
2418: THEN
2419: -- Set the Module Name
2420: l_module_name := 'ams'||DELIMETER||'plsql'||DELIMETER||G_PACKAGE_NAME||DELIMETER||p_procedure_name||DELIMETER||LABEL_PREFIX||'-'||p_label;
2421: -- Log the Message

Line 2422: AMS_UTILITY_PVT.debug_message(p_log_level,

2418: THEN
2419: -- Set the Module Name
2420: l_module_name := 'ams'||DELIMETER||'plsql'||DELIMETER||G_PACKAGE_NAME||DELIMETER||p_procedure_name||DELIMETER||LABEL_PREFIX||'-'||p_label;
2421: -- Log the Message
2422: AMS_UTILITY_PVT.debug_message(p_log_level,
2423: l_module_name,
2424: p_text
2425: );
2426: END IF;

Line 2622: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,G_module_name,l_full_name||':Start');

2618:
2619: x_return_status := FND_API.g_ret_sts_success;
2620: -- checking if cat_id and inv id is passed,assoc exist.
2621: IF (AMS_LOG_PROCEDURE_ON) THEN
2622: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,G_module_name,l_full_name||':Start');
2623: END IF;
2624:
2625: IF (( p_act_product_rec.inventory_item_id <> FND_API.G_MISS_NUM
2626: AND p_act_product_rec.category_id <> FND_API.G_MISS_NUM )

Line 2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);

2640:
2641: IF p_act_product_rec.arc_act_product_used_by = 'CSCH'
2642: THEN
2643: IF (AMS_DEBUG_HIGH_ON) THEN
2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);
2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);
2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);
2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);
2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);

Line 2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);

2641: IF p_act_product_rec.arc_act_product_used_by = 'CSCH'
2642: THEN
2643: IF (AMS_DEBUG_HIGH_ON) THEN
2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);
2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);
2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);
2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);
2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);
2649: END IF;

Line 2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);

2642: THEN
2643: IF (AMS_DEBUG_HIGH_ON) THEN
2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);
2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);
2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);
2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);
2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);
2649: END IF;
2650:

Line 2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);

2643: IF (AMS_DEBUG_HIGH_ON) THEN
2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);
2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);
2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);
2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);
2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);
2649: END IF;
2650:
2651: OPEN get_csch_detl;

Line 2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);

2644: AMS_UTILITY_PVT.debug_message('checking for hierarchy inheritance for schedule:'|| p_act_product_rec.act_product_used_by_id);
2645: AMS_UTILITY_PVT.debug_message('inventory_item_id:'|| p_act_product_rec.inventory_item_id);
2646: AMS_UTILITY_PVT.debug_message('organization_id:'|| p_act_product_rec.organization_id);
2647: AMS_UTILITY_PVT.debug_message('category_id'|| p_act_product_rec.category_id);
2648: AMS_UTILITY_PVT.debug_message('level_type_code'|| p_act_product_rec.level_type_code);
2649: END IF;
2650:
2651: OPEN get_csch_detl;
2652: FETCH get_csch_detl INTO l_campaign_id,l_usage;

Line 2656: AMS_UTILITY_PVT.debug_message('campaign_id:'|| l_campaign_id);

2652: FETCH get_csch_detl INTO l_campaign_id,l_usage;
2653: CLOSE get_csch_detl;
2654:
2655: IF (AMS_DEBUG_HIGH_ON) THEN
2656: AMS_UTILITY_PVT.debug_message('campaign_id:'|| l_campaign_id);
2657: END IF;
2658: IF (AMS_LOG_STATEMENT_ON) THEN
2659: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'inv_id:'
2660: ||p_act_product_rec.inventory_item_id||',cat_id:'||p_act_product_rec.category_id

Line 2659: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'inv_id:'

2655: IF (AMS_DEBUG_HIGH_ON) THEN
2656: AMS_UTILITY_PVT.debug_message('campaign_id:'|| l_campaign_id);
2657: END IF;
2658: IF (AMS_LOG_STATEMENT_ON) THEN
2659: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'inv_id:'
2660: ||p_act_product_rec.inventory_item_id||',cat_id:'||p_act_product_rec.category_id
2661: ||',schId'||p_act_product_rec.act_product_used_by_id ||',campaign_id:'|| l_campaign_id);
2662: END IF;
2663:

Line 2673: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'checking if the product association exist in campaign');

2669: AND p_act_product_rec.organization_id <> FND_API.G_MISS_NUM )
2670: THEN
2671:
2672: IF (AMS_LOG_STATEMENT_ON) THEN
2673: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'checking if the product association exist in campaign');
2674: END IF;
2675: --- checking if the product association exist in campaign
2676: OPEN check_prod_exist;
2677: FETCH check_prod_exist INTO l_count;

Line 2681: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_prod_exist does not exist');

2677: FETCH check_prod_exist INTO l_count;
2678: CLOSE check_prod_exist;
2679: IF l_count = 0 THEN
2680: IF (AMS_LOG_STATEMENT_ON) THEN
2681: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_prod_exist does not exist');
2682: END IF;
2683: --- checking if the category, which is assigned to the product,direct assoc with camp
2684: -- or the category exists in its hierarchy association exist in campaign
2685: If ( p_act_product_rec.category_id IS NOT NULL

Line 2688: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'INSIDE Category, cat-set-id not null condn');

2684: -- or the category exists in its hierarchy association exist in campaign
2685: If ( p_act_product_rec.category_id IS NOT NULL
2686: AND p_Act_product_Rec.category_id <> FND_API.G_MISS_NUM) THEN
2687: IF (AMS_LOG_STATEMENT_ON) THEN
2688: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'INSIDE Category, cat-set-id not null condn');
2689: END IF;
2690: --checking direct assoc
2691: OPEN check_prod_cat_exist;
2692: FETCH check_prod_cat_exist INTO l_count;

Line 2701: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_cat_exist does not exist');

2697: FETCH check_cat_exist_hrchy INTO l_count;
2698: CLOSE check_cat_exist_hrchy;
2699: IF l_count = 0 THEN
2700: IF (AMS_LOG_STATEMENT_ON) THEN
2701: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_cat_exist does not exist');
2702: END IF;
2703: --- both hierarch doesn't exist raising an error
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN

Line 2734: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_cat_exist does not exist');

2730: CLOSE check_cat_exist;
2731: IF l_count = 0
2732: THEN
2733: IF (AMS_LOG_STATEMENT_ON) THEN
2734: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_cat_exist does not exist');
2735: END IF;
2736: -- checking if the category exist in the hierachy
2737: OPEN check_cat_exist_hrchy;
2738: FETCH check_cat_exist_hrchy INTO l_count;

Line 2743: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'HIERARCHY ALSO DOESNT EXIST');

2739: CLOSE check_cat_exist_hrchy;
2740: IF l_count = 0
2741: THEN
2742: IF (AMS_LOG_STATEMENT_ON) THEN
2743: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'HIERARCHY ALSO DOESNT EXIST');
2744: END IF;
2745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2746: THEN
2747: FND_MESSAGE.set_name('AMS', 'AMS_CAT_ASSOC_NOT_IN_CAMP');

Line 2759: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_product_val_for_csch is checked with no errors');

2755: END IF; -- l_usage
2756: END IF; -- obj_type = csch
2757:
2758: IF (AMS_LOG_STATEMENT_ON) THEN
2759: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_product_val_for_csch is checked with no errors');
2760: END IF;
2761:
2762: IF (AMS_LOG_PROCEDURE_ON) THEN
2763: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,l_full_name||'- End');

Line 2763: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,l_full_name||'- End');

2759: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_product_val_for_csch is checked with no errors');
2760: END IF;
2761:
2762: IF (AMS_LOG_PROCEDURE_ON) THEN
2763: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,l_full_name||'- End');
2764: END IF;
2765:
2766: END check_product_val_for_csch;
2767: