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 460: gmd_debug.put_line(' In Formula Detail Pub - '

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

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

472: ,p_formula_detail_rec => l_fm_matl_dtl_rec
473: );
474:
475: IF (l_debug = 'Y') THEN
476: gmd_debug.put_line(' In Formula Detail Pub - '
477: ||' After calling the line Pvt API '
478: ||' - '
479: ||x_return_status);
480: END IF;

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

520: FND_MSG_PUB.Count_And_Get (
521: p_count => x_msg_count,
522: p_data => x_msg_data );
523: IF (l_debug = 'Y') THEN
524: gmd_debug.put_line(' In Formula Detail Pub - In Error Exception Section '
525: ||' - '
526: ||x_return_status);
527: END IF;
528:

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

532: FND_MSG_PUB.Count_And_Get (
533: p_count => x_msg_count,
534: p_data => x_msg_data );
535: IF (l_debug = 'Y') THEN
536: gmd_debug.put_line(' In Formula Detail Pub - In Unexpected Exception Section '
537: ||' - '
538: ||x_return_status);
539: END IF;
540:

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

545: FND_MSG_PUB.Count_And_Get (
546: p_count => x_msg_count,
547: p_data => x_msg_data );
548: IF (l_debug = 'Y') THEN
549: gmd_debug.put_line(' In Formula Detail Pub - In OTHERS Exception Section '
550: ||' - '
551: ||x_return_status);
552: END IF;
553:

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

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

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

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

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

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

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

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

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

848: /* (fm_matl_dtl). If any field value is not provided, update it */
849: /* with what exists in the db */
850: /* ================================================================= */
851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line(' In Formula Detail Pub - '
853: ||' Retrieving all not null columns '
854: ||' for formula line id = '
855: ||p_formula_detail_rec.formulaline_id
856: ||' - '

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

976:
977: /* Validate all optional parameters passed. */
978:
979: IF (l_debug = 'Y') THEN
980: gmd_debug.put_line(' In Formula Detail Pub - '
981: ||' Validation of G-MISS '
982: ||' - '
983: ||x_return_status);
984: END IF;

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

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

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

1074: END IF;
1075: ELSIF (p_formula_detail_rec.contribute_yield_ind IS NULL) THEN
1076: l_contribute_yield_ind := fm_matl_dtl_rec.contribute_yield_ind;
1077: IF (l_debug = 'Y') THEN
1078: gmd_debug.put_line(' In Formula Header Pub - '
1079: ||' Cond 2');
1080: END IF;
1081: ELSE
1082: l_contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;

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

1080: END IF;
1081: ELSE
1082: l_contribute_yield_ind := p_formula_detail_rec.contribute_yield_ind;
1083: IF (l_debug = 'Y') THEN
1084: gmd_debug.put_line(' In Formula Header Pub - '
1085: ||' Cond 3');
1086: END IF;
1087: END IF;
1088:

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

1086: END IF;
1087: END IF;
1088:
1089: IF (l_debug = 'Y') THEN
1090: gmd_debug.put_line(' In Formula Header Pub - '
1091: ||' p_formula_detail_rec.contribute_yield_ind = '
1092: ||p_formula_detail_rec.contribute_yield_ind
1093: ||' fm_matl_dtl_rec.contribute_yield_ind = '
1094: ||fm_matl_dtl_rec.contribute_yield_ind

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

1376: CLOSE get_detail_rec;
1377:
1378: /* Call for private API */
1379: IF (l_debug = 'Y') THEN
1380: gmd_debug.put_line(' In Formula Detail Pub - '
1381: ||' Assigning values prior to pvt API call '
1382: ||' - '
1383: ||x_return_status);
1384: END IF;

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

1450: l_fm_matl_dtl_rec.prod_percent := p_formula_detail_rec.prod_percent;
1451:
1452: /* Call the private API */
1453: IF (l_debug = 'Y') THEN
1454: gmd_debug.put_line(' In Formula Detail Pub - '
1455: ||' Before Updtae Pvt API call '
1456: ||' - '
1457: ||x_return_status);
1458: END IF;

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

1466: ,p_formula_detail_rec => l_fm_matl_dtl_rec
1467: );
1468:
1469: IF (l_debug = 'Y') THEN
1470: gmd_debug.put_line(' In Formula Detail Pub - '
1471: ||' After Update Pvt API call '
1472: ||' - '
1473: ||x_return_status);
1474: END IF;

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

1514: FND_MSG_PUB.Count_And_Get (
1515: p_count => x_msg_count,
1516: p_data => x_msg_data );
1517: IF (l_debug = 'Y') THEN
1518: gmd_debug.put_line(' In Formula Detail pub - In error Exception Section '
1519: ||' - '
1520: ||x_return_status);
1521: END IF;
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1525: FND_MSG_PUB.Count_And_Get (
1526: p_count => x_msg_count,
1527: p_data => x_msg_data );
1528: IF (l_debug = 'Y') THEN
1529: gmd_debug.put_line(' In Formula Detail pub - In unexpected Exception Section '
1530: ||' - '
1531: ||x_return_status);
1532: END IF;
1533: WHEN OTHERS THEN

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

1537: FND_MSG_PUB.Count_And_Get (
1538: p_count => x_msg_count,
1539: p_data => x_msg_data );
1540: IF (l_debug = 'Y') THEN
1541: gmd_debug.put_line(' In Formula Detail pub - In OTHERS Exception Section '
1542: ||' - '
1543: ||x_return_status);
1544: END IF;
1545:

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

1703: /* ======================== */
1704: /* Get the formula id */
1705: /* ======================== */
1706: IF (l_debug = 'Y') THEN
1707: gmd_debug.put_line(' In Formula Detail Pub - '
1708: ||' Before formula validation - '||x_return_status);
1709: END IF;
1710:
1711: IF (p_formula_detail_rec.formula_id is NULL) THEN