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 210: gmd_debug.put_line(' ');

206:
207: FOR i IN 1 .. p_formula_header_tbl.count LOOP
208:
209: IF (l_debug = 'Y') THEN
210: gmd_debug.put_line(' ');
211: gmd_debug.put_line(' ');
212: END IF;
213:
214: IF (l_debug = 'Y') THEN

Line 211: gmd_debug.put_line(' ');

207: FOR i IN 1 .. p_formula_header_tbl.count LOOP
208:
209: IF (l_debug = 'Y') THEN
210: gmd_debug.put_line(' ');
211: gmd_debug.put_line(' ');
212: END IF;
213:
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);

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

211: gmd_debug.put_line(' ');
212: END IF;
213:
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);
216: END IF;
217:
218: /* Initialize return status for every header row */
219: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

237: -- Assigning Formulaline to formula detail table type
238: l_formula_detail_tbl(1) := p_formula_header_tbl(i);
239:
240: IF (l_debug = 'Y') THEN
241: gmd_debug.put_line(' In Formula Header Pub - Before User_id val');
242: END IF;
243:
244:
245: /* ======================================= */

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

252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF (l_debug = 'Y') THEN
256: gmd_debug.put_line(' In Formula Header Pub - Before formula id val '
257: ||p_formula_header_rec.formula_no||' - '
258: ||p_formula_header_rec.formula_vers||' - '
259: ||l_formula_id);
260: END IF;

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

340: l_formula_vers := p_formula_header_rec.formula_vers;
341:
342:
343: IF (l_debug = 'Y') THEN
344: gmd_debug.put_line(' In Formula Header Pub - '
345: ||'Checking for 1 prod and 1 ingr - Scenario 1 '
346: ||x_return_status);
347: END IF;
348: /* ================================ */

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

398: END IF;
399: END IF;
400:
401: IF (l_debug = 'Y') THEN
402: gmd_debug.put_line(' In Formula Header Pub - '
403: ||'Checking for 1 prod and 1 ingr - Scenario 2 '
404: ||x_return_status);
405: END IF;
406: /* Scenario 2 we come across a product or ingredient */

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

449: -- If user does not provide the orgn code the information
450: -- then we get this value from default user level profile option
451: -- Bug 4603060 removed owner_id reference
452: IF (l_debug = 'Y') THEN
453: gmd_debug.put_line(' In Formula Header Pub - '
454: ||'Before deriving the orgn_code Owner id / User id = '
455: ||l_user_id
456: ||' / '
457: ||l_user_id);

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

521: END LOOP; */
522: /* Bug No.6799624 - End */
523:
524: IF (l_debug = 'Y') THEN
525: gmd_debug.put_line(' In Formula Header Pub - '
526: ||'Before chceking for header exists flag '
527: ||l_header_exists_flag);
528: END IF;
529:

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

534: /* Only in Inserts */
535: /* To insert a header it should have formula description */
536: /* ===================================================== */
537: IF (l_debug = 'Y') THEN
538: gmd_debug.put_line(' In Formula Header Pub - '
539: ||'Before validation of formula desc '
540: ||p_formula_header_rec.formula_desc1
541: ||' - '
542: ||x_return_status);

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

552: /* ===================================== */
553: /* Validate the formula type */
554: /* ===================================== */
555: IF (l_debug = 'Y') THEN
556: gmd_debug.put_line(' In Formula Header Pub - '
557: ||'Before validation of formula type '
558: ||p_formula_header_rec.formula_type
559: ||' - '
560: ||x_return_status);

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

571: /* ======================================= */
572: /* Check the scale type for formula header */
573: /* ======================================= */
574: IF (l_debug = 'Y') THEN
575: gmd_debug.put_line(' In Formula Header Pub - '
576: ||'Before validation of header scale type '
577: ||p_formula_header_rec.scale_type_hdr
578: ||' - '
579: ||x_return_status);

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

595: /* ====================== */
596: /* Validate formula_class */
597: /* ====================== */
598: IF (l_debug = 'Y') THEN
599: gmd_debug.put_line(' In Formula Header Pub - '
600: ||'Before validation of formula class '
601: ||p_formula_header_rec.formula_class
602: ||' - '
603: ||x_return_status);

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

616: /* ================================================== */
617: /* Need to get the surrogate key value for formula id */
618: /* ================================================== */
619: IF (l_debug = 'Y') THEN
620: gmd_debug.put_line(' In Formula Header Pub - '
621: ||'Getting the Surrogate key : The formula id = '
622: ||p_formula_header_rec.formula_id
623: ||' - '
624: ||x_return_status);

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

641: /* ================================================== */
642: /* Call the private API to insert header information */
643: /* ================================================== */
644: IF (l_debug = 'Y') THEN
645: gmd_debug.put_line(' In Formula Header Pub - '
646: ||'About to assign values before calling pvt API '
647: ||' - '
648: ||x_return_status);
649: END IF;

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

717: -- Kapil Auto ME :Bug# 5716318
718: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
719:
720: IF (l_debug = 'Y') THEN
721: gmd_debug.put_line(' In Formula Header Pub - '
722: ||'About to call the FM Pvt API '
723: ||l_fm_form_mst_rec.formula_id
724: ||' - '
725: ||x_return_status);

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

740: formula_ids.EXTEND ;
741: formula_ids(l_cnt) := l_fm_form_mst_rec.formula_id ;
742: /* Bug No.8753171 - End */
743: IF (l_debug = 'Y') THEN
744: gmd_debug.put_line(' In Formula Header Pub - '
745: ||'After the FM Pvt API call '
746: ||' - '
747: ||x_return_status);
748: END IF;

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

796:
797: /* Create formulalines only if the header is succesfully created */
798: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
799: IF (l_debug = 'Y') THEN
800: gmd_debug.put_line(' In Formula Header Pub - '
801: ||'About to call the Formula line Pub API '
802: ||' - '
803: ||x_return_status);
804: END IF;

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

838: END;
839: /* Bug No.8753171 - End */
840:
841: IF (l_debug = 'Y') THEN
842: gmd_debug.put_line(' In Formula Header Pub - '
843: ||'After the Formula line Pub API call '
844: ||' - '
845: ||x_return_status);
846: END IF;

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

944: FND_MSG_PUB.Count_And_Get (
945: p_count => x_msg_count,
946: p_data => x_msg_data );
947: IF (l_debug = 'Y') THEN
948: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '
949: ||' - '
950: ||x_return_status);
951: END IF;
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

955: FND_MSG_PUB.Count_And_Get (
956: p_count => x_msg_count,
957: p_data => x_msg_data );
958: IF (l_debug = 'Y') THEN
959: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '
960: ||' - '
961: ||x_return_status);
962: END IF;
963: WHEN RECIPE_GENERATE_ERROR THEN

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

966: FND_MSG_PUB.Count_And_Get (
967: p_count => x_msg_count,
968: p_data => x_msg_data );
969: IF (l_debug = 'Y') THEN
970: gmd_debug.put_line(' In Formula Header Pub - In Recipe Generate Exception Section '
971: ||' - '
972: ||x_return_status);
973: END IF;
974: WHEN OTHERS THEN

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

978: FND_MSG_PUB.Count_And_Get (
979: p_count => x_msg_count,
980: p_data => x_msg_data );
981: IF (l_debug = 'Y') THEN
982: gmd_debug.put_line(' In Formula Header Pub - In Others Exception Section '
983: ||' - '
984: ||x_return_status);
985: END IF;
986: END Insert_Formula;

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

1102: /* Initialize API return status to success */
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: IF (l_debug = 'Y') THEN
1106: gmd_debug.put_line(' In Formula Header Pub - Entering loop with row # '||i);
1107: END IF;
1108:
1109: p_formula_header_rec := p_formula_header_tbl(i);
1110:

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

1111: /* ======================================= */
1112: /* Check if there is a valid userid/ownerid */
1113: /* ======================================== */
1114: IF (l_debug = 'Y') THEN
1115: gmd_debug.put_line(' In Formula Header Pub - Before user validation ');
1116: END IF;
1117: -- Bug 4603060
1118: IF (l_user_id IS NULL) THEN
1119: FND_MESSAGE.SET_NAME('GMD', 'GMD_USER_CONTEXT_NOT_SET');

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

1126: /* For updates we must */
1127: /* have a formula id */
1128: /* ==================== */
1129: IF (l_debug = 'Y') THEN
1130: gmd_debug.put_line(' Before formula validation - '||x_return_status);
1131: END IF;
1132: IF (p_formula_header_rec.formula_id is NULL) THEN
1133: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1134: p_formula_header_rec.formula_vers,

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

1158: /* is not provided, update it with what */
1159: /* exists in the db */
1160: /* ==================================== */
1161: IF (l_debug = 'Y') THEN
1162: gmd_debug.put_line(' Assigning all not nulls from db - '||x_return_status);
1163: END IF;
1164:
1165: FOR update_not_null_rec IN get_formula_in_db(l_formula_id)
1166: LOOP

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

1278: /* ===================================== */
1279: /* Validate the formula type */
1280: /* ===================================== */
1281: IF (l_debug = 'Y') THEN
1282: gmd_debug.put_line(' Before formula type validation - '
1283: ||p_formula_header_rec.formula_type
1284: ||' - '
1285: ||x_return_status);
1286: END IF;

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

1296: /* ==================== */
1297: /* Check the scale type */
1298: /* ==================== */
1299: IF (l_debug = 'Y') THEN
1300: gmd_debug.put_line(' Before scale type validation - '
1301: ||p_formula_header_rec.scale_type_hdr
1302: ||' - '
1303: ||x_return_status);
1304: END IF;

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

1326: /* ====================== */
1327: /* Validate formula_class */
1328: /* ====================== */
1329: IF (l_debug = 'Y') THEN
1330: gmd_debug.put_line(' Before formula class validation - '
1331: ||p_formula_header_rec.formula_class
1332: ||' - '
1333: ||x_return_status);
1334: END IF;

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

1352: /* passes in FND_API.G_MISS_CHAR for an attribute it would be handled */
1353: /* as the user is intending to update the field to NULL */
1354: /* Validate all optional parameters passed */
1355: IF (l_debug = 'Y') THEN
1356: gmd_debug.put_line(' Before G-MISS validation - '
1357: ||p_formula_header_rec.formula_id
1358: ||' - '
1359: ||x_return_status);
1360: END IF;

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

1642: /* ========================================================= */
1643: /* Validate formula_class KSHUKLA added as per as bug 5111320*/
1644: /* ========================================================== */
1645: IF (l_debug = 'Y') THEN
1646: gmd_debug.put_line(' Before formula class validation - '
1647: ||p_formula_header_rec.formula_class
1648: ||' - '
1649: ||x_return_status);
1650: END IF;

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

1721: l_fm_form_mst_rec.auto_product_calc := p_formula_header_rec.auto_product_calc;
1722:
1723: /* Validate all optional parameters passed */
1724: IF (l_debug = 'Y') THEN
1725: gmd_debug.put_line(' Before calling the private fm update API - '
1726: ||x_return_status);
1727: END IF;
1728: GMD_FORMULA_HEADER_PVT.Update_FormulaHeader
1729: ( p_api_version => 1.0

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

1734: ,x_msg_data => x_msg_data
1735: ,p_formula_header_rec => l_fm_form_mst_rec
1736: );
1737: IF (l_debug = 'Y') THEN
1738: gmd_debug.put_line('After the private fm update API - '
1739: ||x_return_status);
1740: END IF;
1741:
1742: l_lastformula_id := l_formula_id; -- Assign the last formula header updated.

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

1787: FND_MSG_PUB.Count_And_Get (
1788: p_count => x_msg_count,
1789: p_data => x_msg_data );
1790: IF (l_debug = 'Y') THEN
1791: gmd_debug.put_line(' In Formula Header Pub - In Error Exception Section '
1792: ||' - '
1793: ||x_return_status);
1794: END IF;
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1798: FND_MSG_PUB.Count_And_Get (
1799: p_count => x_msg_count,
1800: p_data => x_msg_data );
1801: IF (l_debug = 'Y') THEN
1802: gmd_debug.put_line(' In Formula Header Pub - In unexpected Exception Section '
1803: ||' - '
1804: ||x_return_status);
1805: END IF;
1806: WHEN OTHERS THEN

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

1810: FND_MSG_PUB.Count_And_Get (
1811: p_count => x_msg_count,
1812: p_data => x_msg_data );
1813: IF (l_debug = 'Y') THEN
1814: gmd_debug.put_line(' In Formula Header Pub - In OTHERs Exception Section '
1815: ||' - '
1816: ||x_return_status);
1817: END IF;
1818: END Update_FormulaHeader;