DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on GMD_DEBUG

Line 1109: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1105: WHEN app_exception.record_lock_exception THEN
1106: ROLLBACK TO SAVEPOINT update_formula;
1107: X_return_status := FND_API.g_ret_sts_error;
1108: IF (l_debug = 'Y') THEN
1109: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1110: END IF;
1111: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1112: 'TABLE_NAME',
1113: 'FM_FORM_MST_B',

Line 1126: gmd_debug.put_line ('In GMDERESB.pls - Status update failure section');

1122: WHEN STATUS_UPDATE_FAILURE THEN
1123: ROLLBACK TO SAVEPOINT update_formula;
1124: X_return_status := FND_API.g_ret_sts_error;
1125: IF (l_debug = 'Y') THEN
1126: gmd_debug.put_line ('In GMDERESB.pls - Status update failure section');
1127: END IF;
1128:
1129: WHEN OTHERS THEN
1130: ROLLBACK TO SAVEPOINT update_formula;

Line 1311: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1307: WHEN app_exception.record_lock_exception THEN
1308: ROLLBACK TO SAVEPOINT update_operation;
1309: X_return_status := FND_API.g_ret_sts_error;
1310: IF (l_debug = 'Y') THEN
1311: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1312: END IF;
1313: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1314: 'TABLE_NAME',
1315: 'GMD_OPERATIONS_B',

Line 1497: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1493: WHEN app_exception.record_lock_exception THEN
1494: ROLLBACK TO SAVEPOINT update_routing;
1495: X_return_status := FND_API.g_ret_sts_error;
1496: IF (l_debug = 'Y') THEN
1497: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1498: END IF;
1499: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1500: 'TABLE_NAME',
1501: 'GMD_ROUTINGS_B',

Line 1600: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1596: END IF;
1597: CLOSE Cur_get_status_type;
1598:
1599: IF (l_debug= 'Y') THEN
1600: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1601: 'The to status type = '||l_status_type);
1602: END IF;
1603:
1604: /* Bug # 2353561 - Shyam Sitaram */

Line 1612: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1608: IF (l_status_type IN ('800','900','1000') ) THEN
1609: IF GMD_ERES_UTILS.check_recipe_validity_eres (p_recipe_id
1610: ,p_to_status) THEN
1611: IF (l_debug= 'Y') THEN
1612: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1613: 'VR eres sig is required and it has be done manually ');
1614: END IF;
1615:
1616: RAISE VR_ERES_REQ;

Line 1641: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1637: END IF;
1638: END IF;
1639:
1640: IF (l_debug= 'Y') THEN
1641: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1642: 'About to lock this recipe '||p_recipe_id);
1643: END IF;
1644:
1645: SELECT 'x'

Line 1652: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1648: WHERE recipe_id = p_recipe_id
1649: FOR UPDATE OF recipe_status nowait;
1650:
1651: IF (l_debug= 'Y') THEN
1652: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1653: 'About to update recipe with status = '||p_to_status);
1654: END IF;
1655:
1656: UPDATE gmd_recipes_b

Line 1671: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1667: ,p_event_key => p_recipe_id
1668: ,p_status => l_erec_reqd);
1669:
1670: IF (l_debug= 'Y') THEN
1671: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1672: 'Checks if recipe esig is req ');
1673: END IF;
1674:
1675: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 1680: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1676:
1677: IF (l_esig_reqd) THEN
1678:
1679: IF (l_debug= 'Y') THEN
1680: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1681: 'Esig is req with pending sts = '|| p_pending_status);
1682: END IF;
1683:
1684: OPEN Cur_get_status_desc (p_from_status);

Line 1705: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1701:
1702: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1703:
1704: IF (l_debug= 'Y') THEN
1705: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1706: 'Raising Esig event ');
1707: END IF;
1708:
1709: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_RECP_USR_LBL');

Line 1737: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1733: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1734: ,p_parameter_value7=>-1);
1735:
1736: IF (l_debug= 'Y') THEN
1737: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1738: 'After Raise Esig event ');
1739: END IF;
1740:
1741: IF l_esig_reqd THEN

Line 1799: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1795: WHEN app_exception.record_lock_exception THEN
1796: ROLLBACK TO SAVEPOINT update_recipe;
1797: X_return_status := FND_API.g_ret_sts_error;
1798: IF (l_debug = 'Y') THEN
1799: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1800: END IF;
1801: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1802: 'TABLE_NAME',
1803: 'GMD_RECIPES_B',

Line 2013: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

2009: WHEN app_exception.record_lock_exception THEN
2010: ROLLBACK TO SAVEPOINT update_validity;
2011: X_return_status := FND_API.g_ret_sts_error;
2012: IF (l_debug = 'Y') THEN
2013: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2014: END IF;
2015: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2016: 'TABLE_NAME',
2017: 'GMD_RECIPE_VALIDITY_RULES',

Line 2174: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

2170: WHEN app_exception.record_lock_exception THEN
2171: ROLLBACK TO SAVEPOINT update_substitution;
2172: X_return_status := FND_API.g_ret_sts_error;
2173: IF (l_debug = 'Y') THEN
2174: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2175: END IF;
2176: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2177: 'TABLE_NAME',
2178: 'GMD_ITEM_SUBSTITUTION_HDR_B',