DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on PA_HR_UPDATE_PA_ENTITIES

Line 1: PACKAGE BODY pa_hr_update_pa_entities AS

1: PACKAGE BODY pa_hr_update_pa_entities AS
2: /* $Header: PAHRUPDB.pls 120.17 2011/05/20 06:32:10 svmohamm ship $ */
3:
4: -- Global variable for debugging. Bug 4352236.
5: G_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 20: pa_debug.write('PA_HR_UPDATE_PA_ENTITIES', 'log: ' || p_log_msg, 3);

16: -- P_DEBUG_MODE varchar2(1); -- Bug 4352236 - use global variable G_DEBUG_MODE
17: BEGIN
18: -- P_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19: IF (G_DEBUG_MODE ='Y') THEN
20: pa_debug.write('PA_HR_UPDATE_PA_ENTITIES', 'log: ' || p_log_msg, 3);
21: END IF;
22: END log_message;
23:
24:

Line 1047: wf_core.context('pa_hr_update_pa_entities',

1043: --
1044: EXCEPTION
1045: /* WHEN FND_API.G_EXC_ERROR
1046: THEN
1047: wf_core.context('pa_hr_update_pa_entities',
1048: 'Full_Name_Change',
1049: itemtype,
1050: itemkey,
1051: to_char(actid),

Line 1064: wf_core.context('pa_hr_update_pa_entities',

1060: resultout := wf_engine.eng_completed||':'||'F';
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1063: THEN
1064: wf_core.context('pa_hr_update_pa_entities',
1065: 'Full_Name_Change',
1066: itemtype,
1067: itemkey,
1068: to_char(actid),

Line 1083: wf_core.context('pa_hr_update_pa_entities',

1079:
1080: resultout := wf_engine.eng_completed||':'||'F';
1081: */
1082: WHEN OTHERS THEN
1083: wf_core.context('pa_hr_update_pa_entities',
1084: 'Full_Name_Change',
1085: itemtype,
1086: itemkey,
1087: to_char(actid),

Line 1240: -- wf_core.context('pa_hr_update_pa_entities',

1236: THEN
1237: If (l_savepoint) then
1238: rollback to l_ou_change ;
1239: End if;
1240: -- wf_core.context('pa_hr_update_pa_entities',
1241: -- 'Full_Name_Change',
1242: -- itemtype,
1243: -- itemkey,
1244: -- to_char(actid),

Line 1260: -- wf_core.context('pa_hr_update_pa_entities',

1256:
1257: If (l_savepoint) then
1258: rollback to l_ou_change ;
1259: End if;
1260: -- wf_core.context('pa_hr_update_pa_entities',
1261: -- 'Full_Name_Change',
1262: -- itemtype,
1263: -- itemkey,
1264: -- to_char(actid),

Line 1283: -- wf_core.context('pa_hr_update_pa_entities',

1279: WHEN OTHERS THEN
1280: If (l_savepoint) then
1281: rollback to l_ou_change ;
1282: End if;
1283: -- wf_core.context('pa_hr_update_pa_entities',
1284: -- 'Full_Name_Change',
1285: -- itemtype,
1286: -- itemkey,
1287: -- to_char(actid),

Line 1442: wf_core.context('pa_hr_update_pa_entities',

1438: THEN
1439: If (l_savepoint) then
1440: rollback to l_valid_grade_change ;
1441: End if;
1442: wf_core.context('pa_hr_update_pa_entities',
1443: 'Valid_Grade_Change',
1444: itemtype,
1445: itemkey,
1446: to_char(actid),

Line 1459: wf_core.context('pa_hr_update_pa_entities',

1455: THEN
1456: If (l_savepoint) then
1457: rollback to l_valid_grade_change ;
1458: End if;
1459: wf_core.context('pa_hr_update_pa_entities',
1460: 'Valid_Grade_Change',
1461: itemtype,
1462: itemkey,
1463: to_char(actid),

Line 1477: wf_core.context('pa_hr_update_pa_entities',

1473: WHEN OTHERS THEN
1474: If (l_savepoint) then
1475: rollback to l_valid_grade_change ;
1476: End if;
1477: wf_core.context('pa_hr_update_pa_entities',
1478: 'Valid_Grade_Change',
1479: itemtype,
1480: itemkey,
1481: to_char(actid),

Line 1612: wf_core.context('pa_hr_update_pa_entities',

1608: THEN
1609: If (l_savepoint) then
1610: rollback to l_job_level_change ;
1611: End if;
1612: wf_core.context('pa_hr_update_pa_entities',
1613: 'Job_Change',
1614: itemtype,
1615: itemkey,
1616: to_char(actid),

Line 1631: wf_core.context('pa_hr_update_pa_entities',

1627: THEN
1628: If (l_savepoint) then
1629: rollback to l_job_level_change ;
1630: End if;
1631: wf_core.context('pa_hr_update_pa_entities',
1632: 'Job_Change',
1633: itemtype,
1634: itemkey,
1635: to_char(actid),

Line 1651: wf_core.context('pa_hr_update_pa_entities',

1647: WHEN OTHERS THEN
1648: If (l_savepoint) then
1649: rollback to l_job_level_change ;
1650: End if;
1651: wf_core.context('pa_hr_update_pa_entities',
1652: 'Job_Change',
1653: itemtype,
1654: itemkey,
1655: to_char(actid),

Line 1860: wf_core.context('pa_hr_update_pa_entities',

1856: THEN
1857: If (l_savepoint) then
1858: rollback to l_address_change ;
1859: end if;
1860: wf_core.context('pa_hr_update_pa_entities',
1861: 'Address_Change',
1862: itemtype,
1863: itemkey,
1864: to_char(actid),

Line 1880: wf_core.context('pa_hr_update_pa_entities',

1876: THEN
1877: If (l_savepoint) then
1878: rollback to l_address_change ;
1879: End if;
1880: wf_core.context('pa_hr_update_pa_entities',
1881: 'Address_Change',
1882: itemtype,
1883: itemkey,
1884: to_char(actid),

Line 1901: wf_core.context('pa_hr_update_pa_entities',

1897: If (l_savepoint) then
1898: rollback to l_address_change ;
1899: null;
1900: End if;
1901: wf_core.context('pa_hr_update_pa_entities',
1902: 'Address_Change',
1903: itemtype,
1904: itemkey,
1905: to_char(actid),

Line 2114: wf_core.context('pa_hr_update_pa_entities',

2110: THEN
2111: If (l_savepoint) then
2112: rollback to l_project_org_change ;
2113: end if;
2114: wf_core.context('pa_hr_update_pa_entities',
2115: 'Address_Change',
2116: itemtype,
2117: itemkey,
2118: to_char(actid),

Line 2134: wf_core.context('pa_hr_update_pa_entities',

2130: THEN
2131: If (l_savepoint) then
2132: rollback to l_project_org_change ;
2133: End if;
2134: wf_core.context('pa_hr_update_pa_entities',
2135: 'Project_Organization_Change',
2136: itemtype,
2137: itemkey,
2138: to_char(actid),

Line 2157: wf_core.context('pa_hr_update_pa_entities',

2153: If (l_savepoint) then
2154: rollback to l_project_org_change ;
2155: End if;
2156:
2157: wf_core.context('pa_hr_update_pa_entities',
2158: 'Project_Organization_Change',
2159: itemtype,
2160: itemkey,
2161: to_char(actid),

Line 2314: wf_core.context('pa_hr_update_pa_entities',

2310: THEN
2311: If (l_savepoint) then
2312: rollback to l_job_rel_change ;
2313: End if;
2314: wf_core.context('pa_hr_update_pa_entities',
2315: 'Address_Change',
2316: itemtype,
2317: itemkey,
2318: to_char(actid),

Line 2333: wf_core.context('pa_hr_update_pa_entities',

2329: THEN
2330: If (l_savepoint) then
2331: rollback to l_job_rel_change ;
2332: End if;
2333: wf_core.context('pa_hr_update_pa_entities',
2334: 'Address_Change',
2335: itemtype,
2336: itemkey,
2337: to_char(actid),

Line 2354: wf_core.context('pa_hr_update_pa_entities',

2350: If (l_savepoint) then
2351: rollback to l_job_rel_change ;
2352: End if;
2353:
2354: wf_core.context('pa_hr_update_pa_entities',
2355: 'Address_Change',
2356: itemtype,
2357: itemkey,
2358: to_char(actid),

Line 3313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',

3309:
3310: x_return_status := FND_API.G_RET_STS_ERROR;
3311: x_msg_count := 1;
3312: x_msg_data := substr(SQLERRM,1,240);
3313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_HR_UPDATE_PA_ENTITIES',
3314: p_procedure_name => 'create_fte_sync_wf');
3315: If x_msg_count = 1 THEN
3316: pa_interface_utils_pub.get_messages
3317: (p_encoded => FND_API.G_TRUE,

Line 3449: wf_core.context('pa_hr_update_pa_entities',

3445:
3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: log_message('Execption OTHERS, '||SQLERRM ||', '|| SQLCODE);
3449: wf_core.context('pa_hr_update_pa_entities',
3450: 'Start_fte_sync_wf',
3451: itemtype,
3452: itemkey,
3453: to_char(actid),