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.GMD_FORMULA_PUB dependencies on GMD_DEBUG

Line 202: gmd_debug.put_line(' ');

198:
199: FOR i IN 1 .. p_formula_header_tbl.count LOOP
200:
201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line(' ');
203: gmd_debug.put_line(' ');
204: END IF;
205:
206: IF (l_debug = 'Y') THEN

Line 203: gmd_debug.put_line(' ');

199: FOR i IN 1 .. p_formula_header_tbl.count LOOP
200:
201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line(' ');
203: gmd_debug.put_line(' ');
204: END IF;
205:
206: IF (l_debug = 'Y') THEN
207: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);

Line 207: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);

203: gmd_debug.put_line(' ');
204: END IF;
205:
206: IF (l_debug = 'Y') THEN
207: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);
208: END IF;
209:
210: /* Initialize return status for every header row */
211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 233: gmd_debug.put_line(' In Formula Header Pub - Before User_id val');

229: -- Assigning Formulaline to formula detail table type
230: l_formula_detail_tbl(1) := p_formula_header_tbl(i);
231:
232: IF (l_debug = 'Y') THEN
233: gmd_debug.put_line(' In Formula Header Pub - Before User_id val');
234: END IF;
235:
236:
237: /* ======================================= */

Line 248: gmd_debug.put_line(' In Formula Header Pub - Before formula id val '

244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: IF (l_debug = 'Y') THEN
248: gmd_debug.put_line(' In Formula Header Pub - Before formula id val '
249: ||p_formula_header_rec.formula_no||' - '
250: ||p_formula_header_rec.formula_vers||' - '
251: ||l_formula_id);
252: END IF;

Line 313: gmd_debug.put_line(' In Formula Header Pub - '

309: l_formula_vers := p_formula_header_rec.formula_vers;
310:
311:
312: IF (l_debug = 'Y') THEN
313: gmd_debug.put_line(' In Formula Header Pub - '
314: ||'Checking for 1 prod and 1 ingr - Scenario 1 '
315: ||x_return_status);
316: END IF;
317: /* ================================ */

Line 371: gmd_debug.put_line(' In Formula Header Pub - '

367: END IF;
368: END IF;
369:
370: IF (l_debug = 'Y') THEN
371: gmd_debug.put_line(' In Formula Header Pub - '
372: ||'Checking for 1 prod and 1 ingr - Scenario 2 '
373: ||x_return_status);
374: END IF;
375: /* Scenario 2 we come across a product or ingredient */

Line 422: gmd_debug.put_line(' In Formula Header Pub - '

418: -- If user does not provide the orgn code the information
419: -- then we get this value from default user level profile option
420: -- Bug 4603060 removed owner_id reference
421: IF (l_debug = 'Y') THEN
422: gmd_debug.put_line(' In Formula Header Pub - '
423: ||'Before deriving the orgn_code Owner id / User id = '
424: ||l_user_id
425: ||' / '
426: ||l_user_id);

Line 491: gmd_debug.put_line(' In Formula Header Pub - '

487: END LOOP;
488: /* Bug No.6799624 - End */
489:
490: IF (l_debug = 'Y') THEN
491: gmd_debug.put_line(' In Formula Header Pub - '
492: ||'Before chceking for header exists flag '
493: ||l_header_exists_flag);
494: END IF;
495:

Line 504: gmd_debug.put_line(' In Formula Header Pub - '

500: /* Only in Inserts */
501: /* To insert a header it should have formula description */
502: /* ===================================================== */
503: IF (l_debug = 'Y') THEN
504: gmd_debug.put_line(' In Formula Header Pub - '
505: ||'Before validation of formula desc '
506: ||p_formula_header_rec.formula_desc1
507: ||' - '
508: ||x_return_status);

Line 522: gmd_debug.put_line(' In Formula Header Pub - '

518: /* ===================================== */
519: /* Validate the formula type */
520: /* ===================================== */
521: IF (l_debug = 'Y') THEN
522: gmd_debug.put_line(' In Formula Header Pub - '
523: ||'Before validation of formula type '
524: ||p_formula_header_rec.formula_type
525: ||' - '
526: ||x_return_status);

Line 541: gmd_debug.put_line(' In Formula Header Pub - '

537: /* ======================================= */
538: /* Check the scale type for formula header */
539: /* ======================================= */
540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line(' In Formula Header Pub - '
542: ||'Before validation of header scale type '
543: ||p_formula_header_rec.scale_type_hdr
544: ||' - '
545: ||x_return_status);

Line 565: gmd_debug.put_line(' In Formula Header Pub - '

561: /* ====================== */
562: /* Validate formula_class */
563: /* ====================== */
564: IF (l_debug = 'Y') THEN
565: gmd_debug.put_line(' In Formula Header Pub - '
566: ||'Before validation of formula class '
567: ||p_formula_header_rec.formula_class
568: ||' - '
569: ||x_return_status);

Line 586: gmd_debug.put_line(' In Formula Header Pub - '

582: /* ================================================== */
583: /* Need to get the surrogate key value for formula id */
584: /* ================================================== */
585: IF (l_debug = 'Y') THEN
586: gmd_debug.put_line(' In Formula Header Pub - '
587: ||'Getting the Surrogate key : The formula id = '
588: ||p_formula_header_rec.formula_id
589: ||' - '
590: ||x_return_status);

Line 611: gmd_debug.put_line(' In Formula Header Pub - '

607: /* ================================================== */
608: /* Call the private API to insert header information */
609: /* ================================================== */
610: IF (l_debug = 'Y') THEN
611: gmd_debug.put_line(' In Formula Header Pub - '
612: ||'About to assign values before calling pvt API '
613: ||' - '
614: ||x_return_status);
615: END IF;

Line 687: gmd_debug.put_line(' In Formula Header Pub - '

683: -- Kapil Auto ME :Bug# 5716318
684: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
685:
686: IF (l_debug = 'Y') THEN
687: gmd_debug.put_line(' In Formula Header Pub - '
688: ||'About to call the FM Pvt API '
689: ||l_fm_form_mst_rec.formula_id
690: ||' - '
691: ||x_return_status);

Line 705: gmd_debug.put_line(' In Formula Header Pub - '

701: ,p_formula_header_rec => l_fm_form_mst_rec
702: );
703:
704: IF (l_debug = 'Y') THEN
705: gmd_debug.put_line(' In Formula Header Pub - '
706: ||'After the FM Pvt API call '
707: ||' - '
708: ||x_return_status);
709: END IF;

Line 761: gmd_debug.put_line(' In Formula Header Pub - '

757:
758: /* Create formulalines only if the header is succesfully created */
759: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
760: IF (l_debug = 'Y') THEN
761: gmd_debug.put_line(' In Formula Header Pub - '
762: ||'About to call the Formula line Pub API '
763: ||' - '
764: ||x_return_status);
765: END IF;

Line 779: gmd_debug.put_line(' In Formula Header Pub - '

775: ,p_formula_detail_tbl => l_formula_detail_tbl
776: );
777:
778: IF (l_debug = 'Y') THEN
779: gmd_debug.put_line(' In Formula Header Pub - '
780: ||'After the Formula line Pub API call '
781: ||' - '
782: ||x_return_status);
783: END IF;

Line 880: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

876: FND_MSG_PUB.Count_And_Get (
877: p_count => x_msg_count,
878: p_data => x_msg_data );
879: IF (l_debug = 'Y') THEN
880: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '
881: ||' - '
882: ||x_return_status);
883: END IF;
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 891: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

887: FND_MSG_PUB.Count_And_Get (
888: p_count => x_msg_count,
889: p_data => x_msg_data );
890: IF (l_debug = 'Y') THEN
891: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '
892: ||' - '
893: ||x_return_status);
894: END IF;
895: WHEN RECIPE_GENERATE_ERROR THEN

Line 902: gmd_debug.put_line(' In Formula Header Pub - In Recipe Generate Exception Section '

898: FND_MSG_PUB.Count_And_Get (
899: p_count => x_msg_count,
900: p_data => x_msg_data );
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line(' In Formula Header Pub - In Recipe Generate Exception Section '
903: ||' - '
904: ||x_return_status);
905: END IF;
906: WHEN OTHERS THEN

Line 914: gmd_debug.put_line(' In Formula Header Pub - In Others Exception Section '

910: FND_MSG_PUB.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data );
913: IF (l_debug = 'Y') THEN
914: gmd_debug.put_line(' In Formula Header Pub - In Others Exception Section '
915: ||' - '
916: ||x_return_status);
917: END IF;
918: END Insert_Formula;

Line 1037: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);

1033: /* Initialize API return status to success */
1034: x_return_status := FND_API.G_RET_STS_SUCCESS;
1035:
1036: IF (l_debug = 'Y') THEN
1037: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);
1038: END IF;
1039:
1040: p_formula_header_rec := p_formula_header_tbl(i);
1041:

Line 1046: gmd_debug.put_line(' In Formula Header Pub - Before user validation ');

1042: /* ======================================= */
1043: /* Check if there is a valid userid/ownerid */
1044: /* ======================================== */
1045: IF (l_debug = 'Y') THEN
1046: gmd_debug.put_line(' In Formula Header Pub - Before user validation ');
1047: END IF;
1048: -- Bug 4603060
1049: IF (l_user_id IS NULL) THEN
1050: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');

Line 1061: gmd_debug.put_line(' Before formula validation - '||x_return_status);

1057: /* For updates we must */
1058: /* have a formula id */
1059: /* ==================== */
1060: IF (l_debug = 'Y') THEN
1061: gmd_debug.put_line(' Before formula validation - '||x_return_status);
1062: END IF;
1063: IF (p_formula_header_rec.formula_id is NULL) THEN
1064: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1065: p_formula_header_rec.formula_vers,

Line 1093: gmd_debug.put_line(' Assigning all not nulls from db - '||x_return_status);

1089: /* is not provided, update it with what */
1090: /* exists in the db */
1091: /* ==================================== */
1092: IF (l_debug = 'Y') THEN
1093: gmd_debug.put_line(' Assigning all not nulls from db - '||x_return_status);
1094: END IF;
1095:
1096: FOR update_not_null_rec IN get_formula_in_db(l_formula_id)
1097: LOOP

Line 1208: gmd_debug.put_line(' Before formula type validation - '

1204: /* ===================================== */
1205: /* Validate the formula type */
1206: /* ===================================== */
1207: IF (l_debug = 'Y') THEN
1208: gmd_debug.put_line(' Before formula type validation - '
1209: ||p_formula_header_rec.formula_type
1210: ||' - '
1211: ||x_return_status);
1212: END IF;

Line 1226: gmd_debug.put_line(' Before scale type validation - '

1222: /* ==================== */
1223: /* Check the scale type */
1224: /* ==================== */
1225: IF (l_debug = 'Y') THEN
1226: gmd_debug.put_line(' Before scale type validation - '
1227: ||p_formula_header_rec.scale_type_hdr
1228: ||' - '
1229: ||x_return_status);
1230: END IF;

Line 1256: gmd_debug.put_line(' Before formula class validation - '

1252: /* ====================== */
1253: /* Validate formula_class */
1254: /* ====================== */
1255: IF (l_debug = 'Y') THEN
1256: gmd_debug.put_line(' Before formula class validation - '
1257: ||p_formula_header_rec.formula_class
1258: ||' - '
1259: ||x_return_status);
1260: END IF;

Line 1282: gmd_debug.put_line(' Before G-MISS validation - '

1278: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */
1279: /* as the user is intending to update the field to NULL */
1280: /* Validate all optional parameters passed */
1281: IF (l_debug = 'Y') THEN
1282: gmd_debug.put_line(' Before G-MISS validation - '
1283: ||p_formula_header_rec.formula_id
1284: ||' - '
1285: ||x_return_status);
1286: END IF;

Line 1572: gmd_debug.put_line(' Before formula class validation - '

1568: /* ========================================================= */
1569: /* Validate formula_class KSHUKLA added as per as bug 5111320*/
1570: /* ========================================================== */
1571: IF (l_debug = 'Y') THEN
1572: gmd_debug.put_line(' Before formula class validation - '
1573: ||p_formula_header_rec.formula_class
1574: ||' - '
1575: ||x_return_status);
1576: END IF;

Line 1651: gmd_debug.put_line(' Before calling the private fm update API - '

1647: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1648:
1649: /* Validate all optional parameters passed */
1650: IF (l_debug = 'Y') THEN
1651: gmd_debug.put_line(' Before calling the private fm update API - '
1652: ||x_return_status);
1653: END IF;
1654: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader
1655: ( p_api_version => 1.0

Line 1664: gmd_debug.put_line('After the private fm update API - '

1660: ,x_msg_data => x_msg_data
1661: ,p_formula_header_rec => l_fm_form_mst_rec
1662: );
1663: IF (l_debug = 'Y') THEN
1664: gmd_debug.put_line('After the private fm update API - '
1665: ||x_return_status);
1666: END IF;
1667:
1668:

Line 1716: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '

1712: FND_MSG_PUB.Count_And_Get (
1713: p_count => x_msg_count,
1714: p_data => x_msg_data );
1715: IF (l_debug = 'Y') THEN
1716: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '
1717: ||' - '
1718: ||x_return_status);
1719: END IF;
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1727: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '

1723: FND_MSG_PUB.Count_And_Get (
1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726: IF (l_debug = 'Y') THEN
1727: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '
1728: ||' - '
1729: ||x_return_status);
1730: END IF;
1731: WHEN OTHERS THEN

Line 1739: gmd_debug.put_line(' In Formula Header Pub - In OTHERs Exception Section '

1735: FND_MSG_PUB.Count_And_Get (
1736: p_count => x_msg_count,
1737: p_data => x_msg_data );
1738: IF (l_debug = 'Y') THEN
1739: gmd_debug.put_line(' In Formula Header Pub - In OTHERs Exception Section '
1740: ||' - '
1741: ||x_return_status);
1742: END IF;
1743: END Update_FormulaHeader;