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_DETAIL_PUB dependencies on GMD_DEBUG

Line 153: gmd_debug.put_line(' ');

149: /* Initialize API return status to success for every line */
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152: IF (l_debug = 'Y') THEN
153: gmd_debug.put_line(' ');
154: gmd_debug.put_line(' ');
155: END IF;
156:
157: IF (l_debug = 'Y') THEN

Line 154: gmd_debug.put_line(' ');

150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151:
152: IF (l_debug = 'Y') THEN
153: gmd_debug.put_line(' ');
154: gmd_debug.put_line(' ');
155: END IF;
156:
157: IF (l_debug = 'Y') THEN
158: gmd_debug.put_line(' In Formula Detail Pub - Entering loop with row # '||i);

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

154: gmd_debug.put_line(' ');
155: END IF;
156:
157: IF (l_debug = 'Y') THEN
158: gmd_debug.put_line(' In Formula Detail Pub - Entering loop with row # '||i);
159: END IF;
160:
161: p_formula_detail_rec := p_formula_detail_tbl(i);
162:

Line 177: gmd_debug.put_line(' In Formula Detail Pub - Before formula id val '

173: /* ================================ */
174: /* Get the formula id if it is NULL */
175: /* ================================ */
176: IF (l_debug = 'Y') THEN
177: gmd_debug.put_line(' In Formula Detail Pub - Before formula id val '
178: ||x_return_status);
179: END IF;
180:
181: IF (p_formula_detail_rec.formula_id is NULL) THEN

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

253:
254: /* Bug No. 6799624 - End */
255:
256: IF (l_debug = 'Y') THEN
257: gmd_debug.put_line(' In Formula Detail Pub - Before User_id val');
258: END IF;
259: -- Bug 4603060 Use the user from context
260: l_user_id := FND_GLOBAL.user_id;
261: IF (l_user_id IS NULL) THEN

Line 272: gmd_debug.put_line(' In Formula Detail Pub - Before detail lines val '

268: /* Check if the same line no and type */
269: /* for that formula does no already exists */
270: /* ======================================= */
271: IF (l_debug = 'Y') THEN
272: gmd_debug.put_line(' In Formula Detail Pub - Before detail lines val '
273: ||x_return_status);
274: END IF;
275:
276:

Line 306: gmd_debug.put_line(' In Formula Detail Pub - Before item id val '

302: END IF;
303:
304: /* Get the item_id which is based on the item no */
305: IF (l_debug = 'Y') THEN
306: gmd_debug.put_line(' In Formula Detail Pub - Before item id val '
307: ||x_return_status);
308: END IF;
309:
310: /* Get the formula line id which is a surrogate key */

Line 312: gmd_debug.put_line(' In Formula Detail Pub - Get the surrogate key '

308: END IF;
309:
310: /* Get the formula line id which is a surrogate key */
311: IF (l_debug = 'Y') THEN
312: gmd_debug.put_line(' In Formula Detail Pub - Get the surrogate key '
313: ||' fmline id = '
314: ||p_formula_detail_rec.formulaline_id
315: ||' - '
316: ||x_return_status);

Line 455: gmd_debug.put_line(' In Formula Detail Pub - '

451: -- Kapil ME Auto-Prod :Bug#5716318
452: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
453: /* Call the private API */
454: IF (l_debug = 'Y') THEN
455: gmd_debug.put_line(' In Formula Detail Pub - '
456: ||' About to call the line Pvt API '
457: ||' - '
458: ||x_return_status);
459: END IF;

Line 471: gmd_debug.put_line(' In Formula Detail Pub - '

467: ,p_formula_detail_rec => l_fm_matl_dtl_rec
468: );
469:
470: IF (l_debug = 'Y') THEN
471: gmd_debug.put_line(' In Formula Detail Pub - '
472: ||' After calling the line Pvt API '
473: ||' - '
474: ||x_return_status);
475: END IF;

Line 519: gmd_debug.put_line(' In Formula Detail Pub - In Error Exception Section '

515: FND_MSG_PUB.Count_And_Get (
516: p_count => x_msg_count,
517: p_data => x_msg_data );
518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line(' In Formula Detail Pub - In Error Exception Section '
520: ||' - '
521: ||x_return_status);
522: END IF;
523:

Line 531: gmd_debug.put_line(' In Formula Detail Pub - In Unexpected Exception Section '

527: FND_MSG_PUB.Count_And_Get (
528: p_count => x_msg_count,
529: p_data => x_msg_data );
530: IF (l_debug = 'Y') THEN
531: gmd_debug.put_line(' In Formula Detail Pub - In Unexpected Exception Section '
532: ||' - '
533: ||x_return_status);
534: END IF;
535:

Line 544: gmd_debug.put_line(' In Formula Detail Pub - In OTHERS Exception Section '

540: FND_MSG_PUB.Count_And_Get (
541: p_count => x_msg_count,
542: p_data => x_msg_data );
543: IF (l_debug = 'Y') THEN
544: gmd_debug.put_line(' In Formula Detail Pub - In OTHERS Exception Section '
545: ||' - '
546: ||x_return_status);
547: END IF;
548:

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

705: /* Initialize API return status to success */
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: IF (l_debug = 'Y') THEN
709: gmd_debug.put_line(' In Formula Detail Update Pub - Entering loop with row # '||i);
710: END IF;
711:
712: p_formula_detail_rec := p_formula_detail_tbl(i);
713:

Line 729: gmd_debug.put_line(' In Formula Detail Pub - '

725: /* ======================== */
726: /* Get the formula id */
727: /* ======================== */
728: IF (l_debug = 'Y') THEN
729: gmd_debug.put_line(' In Formula Detail Pub - '
730: ||' Before formula validation - '||x_return_status);
731: END IF;
732: IF (p_formula_detail_rec.formula_id is NULL) THEN
733: GMDFMVAL_PUB.get_formula_id(p_formula_detail_rec.formula_no,

Line 775: gmd_debug.put_line(' In Formula Detail Pub - '

771: END IF;
772:
773: /* Check if there is a valid userid */
774: IF (l_debug = 'Y') THEN
775: gmd_debug.put_line(' In Formula Detail Pub - '
776: ||' - Before user validation ');
777: END IF;
778: -- Bug 4603060 User the user_id from context
779: l_user_id := FND_GLOBAL.user_id;

Line 791: gmd_debug.put_line(' In Formula Detail Pub - '

787: /* Ensure that the formulaline id exists */
788: /* User is forced to pass the formulaline_id */
789: /* ========================================== */
790: IF (l_debug = 'Y') THEN
791: gmd_debug.put_line(' In Formula Detail Pub - '
792: ||' Before formulaline validation - '||x_return_status);
793: END IF;
794: IF (p_formula_detail_rec.formulaline_id IS NOT NULL) THEN /* if invalid formula no */
795: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);

Line 839: gmd_debug.put_line(' In Formula Detail Pub - '

835: /* (fm_matl_dtl). If any field value is not provided, update it */
836: /* with what exists in the db */
837: /* ================================================================= */
838: IF (l_debug = 'Y') THEN
839: gmd_debug.put_line(' In Formula Detail Pub - '
840: ||' Retrieving all not null columns '
841: ||' for formula line id = '
842: ||p_formula_detail_rec.formulaline_id
843: ||' - '

Line 962: gmd_debug.put_line(' In Formula Detail Pub - '

958:
959: /* Validate all optional parameters passed. */
960:
961: IF (l_debug = 'Y') THEN
962: gmd_debug.put_line(' In Formula Detail Pub - '
963: ||' Validation of G-MISS '
964: ||' - '
965: ||x_return_status);
966: END IF;

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

1050:
1051: IF (p_formula_detail_rec.contribute_yield_ind = FND_API.G_MISS_CHAR) THEN
1052: l_contribute_yield_ind := NULL;
1053: IF (l_debug = 'Y') THEN
1054: gmd_debug.put_line(' In Formula Header Pub - '
1055: ||' Cond 1');
1056: END IF;
1057: ELSIF (p_formula_detail_rec.contribute_yield_ind IS NULL) THEN
1058: l_contribute_yield_ind := fm_matl_dtl_rec.contribute_yield_ind;

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

1056: END IF;
1057: ELSIF (p_formula_detail_rec.contribute_yield_ind IS NULL) THEN
1058: l_contribute_yield_ind := fm_matl_dtl_rec.contribute_yield_ind;
1059: IF (l_debug = 'Y') THEN
1060: gmd_debug.put_line(' In Formula Header Pub - '
1061: ||' Cond 2');
1062: END IF;
1063: ELSE
1064: l_contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;

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

1062: END IF;
1063: ELSE
1064: l_contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
1065: IF (l_debug = 'Y') THEN
1066: gmd_debug.put_line(' In Formula Header Pub - '
1067: ||' Cond 3');
1068: END IF;
1069: END IF;
1070:

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

1068: END IF;
1069: END IF;
1070:
1071: IF (l_debug = 'Y') THEN
1072: gmd_debug.put_line(' In Formula Header Pub - '
1073: ||' p_formula_detail_rec.contribute_yield_ind = '
1074: ||p_formula_detail_rec.contribute_yield_ind
1075: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1076: ||fm_matl_dtl_rec.contribute_yield_ind

Line 1362: gmd_debug.put_line(' In Formula Detail Pub - '

1358: CLOSE get_detail_rec;
1359:
1360: /* Call for private API */
1361: IF (l_debug = 'Y') THEN
1362: gmd_debug.put_line(' In Formula Detail Pub - '
1363: ||' Assigning values prior to pvt API call '
1364: ||' - '
1365: ||x_return_status);
1366: END IF;

Line 1435: gmd_debug.put_line(' In Formula Detail Pub - '

1431: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1432:
1433: /* Call the private API */
1434: IF (l_debug = 'Y') THEN
1435: gmd_debug.put_line(' In Formula Detail Pub - '
1436: ||' Before Updtae Pvt API call '
1437: ||' - '
1438: ||x_return_status);
1439: END IF;

Line 1451: gmd_debug.put_line(' In Formula Detail Pub - '

1447: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1448: );
1449:
1450: IF (l_debug = 'Y') THEN
1451: gmd_debug.put_line(' In Formula Detail Pub - '
1452: ||' After Update Pvt API call '
1453: ||' - '
1454: ||x_return_status);
1455: END IF;

Line 1499: gmd_debug.put_line(' In Formula Detail pub - In error Exception Section '

1495: FND_MSG_PUB.Count_And_Get (
1496: p_count => x_msg_count,
1497: p_data => x_msg_data );
1498: IF (l_debug = 'Y') THEN
1499: gmd_debug.put_line(' In Formula Detail pub - In error Exception Section '
1500: ||' - '
1501: ||x_return_status);
1502: END IF;
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1510: gmd_debug.put_line(' In Formula Detail pub - In unexpected Exception Section '

1506: FND_MSG_PUB.Count_And_Get (
1507: p_count => x_msg_count,
1508: p_data => x_msg_data );
1509: IF (l_debug = 'Y') THEN
1510: gmd_debug.put_line(' In Formula Detail pub - In unexpected Exception Section '
1511: ||' - '
1512: ||x_return_status);
1513: END IF;
1514: WHEN OTHERS THEN

Line 1522: gmd_debug.put_line(' In Formula Detail pub - In OTHERS Exception Section '

1518: FND_MSG_PUB.Count_And_Get (
1519: p_count => x_msg_count,
1520: p_data => x_msg_data );
1521: IF (l_debug = 'Y') THEN
1522: gmd_debug.put_line(' In Formula Detail pub - In OTHERS Exception Section '
1523: ||' - '
1524: ||x_return_status);
1525: END IF;
1526:

Line 1688: gmd_debug.put_line(' In Formula Detail Pub - '

1684: /* ======================== */
1685: /* Get the formula id */
1686: /* ======================== */
1687: IF (l_debug = 'Y') THEN
1688: gmd_debug.put_line(' In Formula Detail Pub - '
1689: ||' Before formula validation - '||x_return_status);
1690: END IF;
1691:
1692: IF (p_formula_detail_rec.formula_id is NULL) THEN