DBA Data[Home] [Help]

APPS.PA_EVENT_PVT dependencies on PA_DEBUG

Line 45: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

41:
42: l_product_code NUMBER:=NULL;
43: l_resp_id NUMBER := 0;
44: l_function_allowed VARCHAR2(1);
45: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
46:
47: BEGIN
48:
49:

Line 52: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

48:
49:
50: --Log Message
51: IF l_debug_mode = 'Y' THEN
52: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
53: ,x_msg => 'Beginning of Check Mandatory Parameters1 '
54: ,x_log_level => 5);
55: END IF;
56:

Line 64: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

60: -- Standard call to check for call compatibility.
61:
62: --Log Message
63: IF l_debug_mode = 'Y' THEN
64: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
65: ,x_msg => 'Beginning of api compatibility check '
66: ,x_log_level => 5);
67: End If;
68:

Line 82: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

78: END IF;
79:
80: --Log Message
81: IF l_debug_mode = 'Y' THEN
82: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
83: ,x_msg => 'Beginning of Function security Check'
84: ,x_log_level => 5);
85: End If;
86:

Line 157: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

153:
154: --END OF BUG FIX 3619483
155: --Log Message
156: IF l_debug_mode = 'Y' THEN
157: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
158: ,x_msg => 'Validating Product Code'
159: ,x_log_level => 5);
160: End If;
161:

Line 210: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

206: End If;
207: END IF;
208:
209: IF l_debug_mode = 'Y' THEN
210: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
211: ,x_msg => 'End of Check Mandatory Parameters1 '
212: ,x_log_level => 5);
213: END IF;
214:

Line 267: l_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

263: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
264:
265: AS
266:
267: l_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
268:
269: BEGIN
270:
271: --Log Message

Line 273: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

269: BEGIN
270:
271: --Log Message
272: IF l_debug_mode = 'Y' THEN
273: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
274: ,x_msg => 'Beginning of Check Mandatory Parameters2 '
275: ,x_log_level => 5);
276: END IF;
277:

Line 283: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

279: x_return_status :=FND_API.G_RET_STS_SUCCESS;
280:
281: --Log Message
282: IF l_debug_mode = 'Y' THEN
283: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
284: ,x_msg => 'Checking event reference for null or ^ '
285: ,x_log_level => 5);
286: END IF;
287:

Line 310: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

306: End If;
307:
308: --Log Message
309: IF l_debug_mode = 'Y' THEN
310: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
311: ,x_msg => 'Start of Validations for Create Event '
312: ,x_log_level => 5);
313: END IF;
314:

Line 320: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

316: IF (p_calling_place='CREATE_EVENT') then
317:
318: --Log Message
319: IF l_debug_mode = 'Y' THEN
320: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
321: ,x_msg => 'Validating Uniqueness of event reference '
322: ,x_log_level => 5);
323: END IF;
324:

Line 350: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

346: End If;
347:
348: --Log Message
349: IF l_debug_mode = 'Y' THEN
350: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
351: ,x_msg => 'Checking project number for null or ^ '
352: ,x_log_level => 5);
353: END IF;
354:

Line 376: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

372: END IF;
373:
374: --Log Message
375: IF l_debug_mode = 'Y' THEN
376: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
377: ,x_msg => 'Checking Event type for null or ^ '
378: ,x_log_level => 5);
379: END IF;
380:

Line 402: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

398: END IF;
399:
400: --Log Message
401: IF l_debug_mode = 'Y' THEN
402: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
403: ,x_msg => 'Checking organization name for null or ^ '
404: ,x_log_level => 5);
405: END IF;
406:

Line 428: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'

424: END IF;
425:
426: --Log Message
427: IF l_debug_mode = 'Y' THEN
428: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS2.begin'
429: ,x_msg => 'End of Validations for Create Event '
430: ,x_log_level => 5);
431: END IF;
432:

Line 436: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'

432:
433: END IF; /* end of validations for create_event */
434:
435: IF l_debug_mode = 'Y' THEN
436: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin'
437: ,x_msg => 'End of Check Mandatory Parameters2'
438: ,x_log_level => 5);
439: END IF;
440:

Line 514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

510: p_api_name VARCHAR2(100):='CHECK_CREATE_EVENT_OK';
511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
513: l_return_status VARCHAR2(1):='Y';
514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
515: l_ret_status VARCHAR2(2000):=NULL;
516: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added for bug 3013137 and 3009307
517: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added for bug 3013137 and 3009307
518:

Line 522: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

518:
519: BEGIN
520: --Log Message
521: IF l_debug_mode = 'Y' THEN
522: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
523: ,x_msg => 'Beginning of Check Create Event Ok'
524: ,x_log_level => 5);
525: END IF;
526:

Line 529: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

525: END IF;
526:
527: --Log Message
528: IF l_debug_mode = 'Y' THEN
529: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
530: ,x_msg => 'Validating task for the given project'
531: ,x_log_level => 5);
532: END IF;
533:

Line 561: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

557: Return(l_return_status); --If task_id is invalid then terminate further validation
558: End If;
559: --Log Message
560: IF l_debug_mode = 'Y' THEN
561: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
562: ,x_msg => 'Validating funding level of the project'
563: ,x_log_level => 5);
564: END IF;
565: Else

Line 593: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

589: End If;
590:
591: -- log Message -- Start of Federal Uptake
592: IF l_debug_mode = 'Y' THEN
593: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
594: ,x_msg => 'Validating agreement for the given project'
595: ,x_log_level => 5);
596: END IF;
597:

Line 632: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

628: End IF;
629:
630: --Log Message
631: IF l_debug_mode = 'Y' THEN
632: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
633: ,x_msg => 'Validating event date is between agreement date'
634: ,x_log_level => 5);
635: END IF;
636:

Line 666: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

662: -- End of Federal Uptake
663:
664: --Log Message
665: IF l_debug_mode = 'Y' THEN
666: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
667: ,x_msg => 'Validating the event_type'
668: ,x_log_level => 5);
669: END IF;
670:

Line 822: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

818: --End of Bug fix3619483
819:
820: --Log Message
821: IF l_debug_mode = 'Y' THEN
822: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
823: ,x_msg => 'Validating organisation name and deriving organisation_id'
824: ,x_log_level => 5);
825: END IF;
826: --calls PA_EVENT_UTILS.CHECK_VALID_EVENT_ORG to validate and

Line 855: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

851: Then
852:
853: --Log Message
854: IF l_debug_mode = 'Y' THEN
855: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
856: ,x_msg => 'Start of MCB Validations '
857: ,x_log_level => 5);
858: END IF;
859:

Line 862: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

858: END IF;
859:
860: --Log Message
861: IF l_debug_mode = 'Y' THEN
862: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
863: ,x_msg => 'Validating bill trans currency code'
864: ,x_log_level => 5);
865: END IF;
866:

Line 896: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

892: End If;
893:
894: --Log Message
895: IF l_debug_mode = 'Y' THEN
896: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
897: ,x_msg => 'Validating funding rate type'
898: ,x_log_level => 5);
899: END IF;
900:

Line 981: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

977: End If;
978: /*End of change for bug 3053190 */
979: --Log Message
980: IF l_debug_mode = 'Y' THEN
981: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
982: ,x_msg => 'Validating project rate type.'
983: ,x_log_level => 5);
984: END IF;
985: /*We validate the PC attributes only when PC<>PFC for Bug 3045302*/

Line 1088: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1084: /*End of change for bug 3053190 */
1085: END IF;/*P_project_currency_code <> P_proj_func_currency_code */
1086: --Log Message
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1089: ,x_msg => 'Validating project functional rate type.'
1090: ,x_log_level => 5);
1091: END IF;
1092:

Line 1220: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1216: End If;
1217:
1218: --Log Message
1219: IF l_debug_mode = 'Y' THEN
1220: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1221: ,x_msg => 'Validating the Adjusting Revenue flag.'
1222: ,x_log_level => 5);
1223: END IF;
1224:

Line 1269: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1265: End If;
1266:
1267: --Log Message
1268: IF l_debug_mode = 'Y' THEN
1269: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1270: ,x_msg => 'Validating the revenue amount.'
1271: ,x_log_level => 5);
1272: END IF;
1273:

Line 1378: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1374: End If;
1375:
1376: --Log Message
1377: IF l_debug_mode = 'Y' THEN
1378: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1379: ,x_msg => 'Validating the bill amount.'
1380: ,x_log_level => 5);
1381: END IF;
1382:

Line 1424: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1420: End If;
1421:
1422: --Log Message
1423: IF l_debug_mode = 'Y' THEN
1424: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1425: ,x_msg => 'Validating the Bill hold flag.'
1426: ,x_log_level => 5);
1427: END IF;
1428:

Line 1455: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1451: End If;
1452:
1453: --Log Message
1454: IF l_debug_mode = 'Y' THEN
1455: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1456: ,x_msg => 'Validating event number.'
1457: ,x_log_level => 5);
1458: END IF;
1459:

Line 1486: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1482: End If;
1483:
1484: --Log Message
1485: IF l_debug_mode = 'Y' THEN
1486: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1487: ,x_msg => 'Validating inventory organization name and deriving inventory organization id.'
1488: ,x_log_level => 5);
1489: END IF;
1490:

Line 1517: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1513: End If;
1514:
1515: --Log Message
1516: IF l_debug_mode = 'Y' THEN
1517: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1518: ,x_msg => 'Validating inventory item id.'
1519: ,x_log_level => 5);
1520: END IF;
1521:

Line 1546: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'

1542: End If;
1543:
1544: --Log Message
1545: IF l_debug_mode = 'Y' THEN
1546: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_EVENT_OK.begin'
1547: ,x_msg => 'End of Check Create Event Ok'
1548: ,x_log_level => 5);
1549: END IF;
1550:

Line 1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
1629: l_return_status VARCHAR2(1):='Y';
1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1631: l_ret_status VARCHAR2(2000):=NULL;
1632:
1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307

Line 1654: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1650: BEGIN
1651:
1652: --Log Message
1653: IF l_debug_mode = 'Y' THEN
1654: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1655: ,x_msg => 'Beginning of Check Update Event Ok'
1656: ,x_log_level => 5);
1657: END IF;
1658:

Line 1661: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1657: END IF;
1658:
1659: --Log Message
1660: IF l_debug_mode = 'Y' THEN
1661: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1662: ,x_msg => 'Validating if the event is processed.'
1663: ,x_log_level => 5);
1664: END IF;
1665: /*We are getting the processed status of the event and store it in the variable l_event_processed for future

Line 1817: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1813: End If;
1814:
1815: --Log Message
1816: IF l_debug_mode = 'Y' THEN
1817: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1818: ,x_msg => 'Validating task for the given project'
1819: ,x_log_level => 5);
1820: END IF;
1821:

Line 1857: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1853: where event_id = P_event_in_rec.P_event_id;
1854: End If;
1855: --Log Message
1856: IF l_debug_mode = 'Y' THEN
1857: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1858: ,x_msg => 'Validating funding level of the project'
1859: ,x_log_level => 5);
1860: END IF;
1861:

Line 1887: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1883: End If;
1884:
1885: -- log Message -- Start Federal Uptake
1886: IF l_debug_mode = 'Y' THEN
1887: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1888: ,x_msg => 'Validating agreement for the given project'
1889: ,x_log_level => 5);
1890: END IF;
1891:

Line 1939: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_UPDATE_OK.begin'

1935: END IF;
1936:
1937: --Log Message
1938: IF l_debug_mode = 'Y' THEN
1939: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_CREATE_UPDATE_OK.begin'
1940: ,x_msg => 'Validating event date is between agreement date'
1941: ,x_log_level => 5);
1942: END IF;
1943:

Line 1984: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

1980: -- End Federal Uptake
1981:
1982: --Log Message
1983: IF l_debug_mode = 'Y' THEN
1984: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
1985: ,x_msg => 'Validating the event_type'
1986: ,x_log_level => 5);
1987: END IF;
1988:

Line 2115: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2111: END IF;
2112: --End of Bug fix 3619483
2113: --Log Message
2114: IF l_debug_mode = 'Y' THEN
2115: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2116: ,x_msg => 'Validating organisation name and deriving organisation_id'
2117: ,x_log_level => 5);
2118: END IF;
2119:

Line 2179: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2175: Then
2176:
2177: --Log Message
2178: IF l_debug_mode = 'Y' THEN
2179: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2180: ,x_msg => 'Start of MCB Validations '
2181: ,x_log_level => 5);
2182: END IF;
2183:

Line 2186: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2182: END IF;
2183:
2184: --Log Message
2185: IF l_debug_mode = 'Y' THEN
2186: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2187: ,x_msg => 'Validating bill trans currency code'
2188: ,x_log_level => 5);
2189: END IF;
2190:

Line 2228: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2224: End If;
2225:
2226: --Log Message
2227: IF l_debug_mode = 'Y' THEN
2228: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2229: ,x_msg => 'Validating funding rate type'
2230: ,x_log_level => 5);
2231: END IF;
2232:

Line 2311: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2307: End If;
2308: /*End of change for bug 3053190 */
2309: --Log Message
2310: IF l_debug_mode = 'Y' THEN
2311: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2312: ,x_msg => 'Validating project rate type.'
2313: ,x_log_level => 5);
2314: END IF;
2315: /*The Project Currency Attributes should not be validated when PC=PFC.

Line 2422: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2418: END IF; /*End of P_project_currency_code <> P_proj_func_currency_code */
2419:
2420: --Log Message
2421: IF l_debug_mode = 'Y' THEN
2422: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2423: ,x_msg => 'Validating project functional rate type.'
2424: ,x_log_level => 5);
2425: END IF;
2426:

Line 2557: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2553: End If;
2554:
2555: --Log Message
2556: IF l_debug_mode = 'Y' THEN
2557: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2558: ,x_msg => 'Validating the Adjusting Revenue flag.'
2559: ,x_log_level => 5);
2560: END IF;
2561:

Line 2620: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2616: End If;
2617:
2618: --Log Message
2619: IF l_debug_mode = 'Y' THEN
2620: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2621: ,x_msg => 'Validating the revenue amount.'
2622: ,x_log_level => 5);
2623: END IF;
2624:

Line 2734: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2730: End If;
2731:
2732: --Log Message
2733: IF l_debug_mode = 'Y' THEN
2734: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2735: ,x_msg => 'Validating the bill amount.'
2736: ,x_log_level => 5);
2737: END IF;
2738:

Line 2781: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2777: End If;
2778:
2779: --Log Message
2780: IF l_debug_mode = 'Y' THEN
2781: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2782: ,x_msg => 'Validating the Bill hold flag.'
2783: ,x_log_level => 5);
2784: END IF;
2785:

Line 2811: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2807: End If;
2808:
2809: --Log Message
2810: IF l_debug_mode = 'Y' THEN
2811: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2812: ,x_msg => 'Validating event number.'
2813: ,x_log_level => 5);
2814: END IF;
2815:

Line 2843: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2839: End If;
2840:
2841: --Log Message
2842: IF l_debug_mode = 'Y' THEN
2843: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2844: ,x_msg => 'Validating inventory organization name and deriving inventory organization id.'
2845: ,x_log_level => 5);
2846: END IF;
2847:

Line 2873: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2869: End If;
2870:
2871: --Log Message
2872: IF l_debug_mode = 'Y' THEN
2873: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2874: ,x_msg => 'Validating inventory item id.'
2875: ,x_log_level => 5);
2876: END IF;
2877:

Line 2902: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'

2898: End If;
2899:
2900: --Log Message
2901: IF l_debug_mode = 'Y' THEN
2902: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PVT.CHECK_UPDATE_EVENT_OK.begin'
2903: ,x_msg => 'End of Check Update Event Ok'
2904: ,x_log_level => 5);
2905: END IF;
2906: