DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PUB dependencies on FND_MSG_PUB

Line 289: FND_MSG_PUB.initialize;

285: END IF;
286:
287: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
288: pa_debug.debug('Performing ID validations and conversions');
289: FND_MSG_PUB.initialize;
290: END IF;
291:
292: --BEGIN VALIDATIONS
293:

Line 393: l_msg_count := FND_MSG_PUB.count_msg;

389: l_task_manager_id := p_task_manager_person_id;
390: END IF;
391:
392: --Check if there is any error
393: l_msg_count := FND_MSG_PUB.count_msg;
394: if l_msg_count > 0 then
395: x_msg_count := l_msg_count;
396: if x_msg_count = 1 then
397: pa_interface_utils_pub.get_messages

Line 544: x_msg_count := FND_MSG_PUB.count_msg;

540: --dbms_output.put_line( 'After exis creat task pvt api call in pub api' );
541:
542: --Check return status
543: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
544: x_msg_count := FND_MSG_PUB.count_msg;
545: if x_msg_count = 1 then
546: pa_interface_utils_pub.get_messages
547: (p_encoded => FND_API.G_TRUE,
548: p_msg_index => 1,

Line 609: x_msg_count := FND_MSG_PUB.count_msg;

605: WHEN FND_API.G_EXC_ERROR THEN
606: IF (p_commit = FND_API.G_TRUE) THEN
607: ROLLBACK to CREATE_TASK;
608: END IF;
609: x_msg_count := FND_MSG_PUB.count_msg;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: WHEN OTHERS THEN
612: IF (p_commit = FND_API.G_TRUE) THEN
613: ROLLBACK to CREATE_TASK;

Line 615: x_msg_count := FND_MSG_PUB.count_msg;

611: WHEN OTHERS THEN
612: IF (p_commit = FND_API.G_TRUE) THEN
613: ROLLBACK to CREATE_TASK;
614: END IF;
615: x_msg_count := FND_MSG_PUB.count_msg;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
618: p_procedure_name => 'CREATE_TASK',
619: p_error_text => substrb(SQLERRM,1,240));

Line 617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

613: ROLLBACK to CREATE_TASK;
614: END IF;
615: x_msg_count := FND_MSG_PUB.count_msg;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
618: p_procedure_name => 'CREATE_TASK',
619: p_error_text => substrb(SQLERRM,1,240));
620: RAISE;
621: END CREATE_TASK;

Line 945: FND_MSG_PUB.initialize;

941: END IF;
942:
943: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
944: pa_debug.debug('Performing ID validations and conversions');
945: FND_MSG_PUB.initialize;
946: END IF;
947:
948: -- Bug 8273954 : Commenting off the below code as it does not do any validations
949: -- and also results in task_manager_person_id to be updated to null when called

Line 1012: l_msg_count := FND_MSG_PUB.count_msg;

1008: l_task_manager_id := p_task_manager_person_id;
1009:
1010:
1011: --Check if there is any error
1012: l_msg_count := FND_MSG_PUB.count_msg;
1013: if l_msg_count > 0 then
1014: x_msg_count := l_msg_count;
1015: if x_msg_count = 1 then
1016: pa_interface_utils_pub.get_messages

Line 1161: x_msg_count := FND_MSG_PUB.count_msg;

1157: );
1158:
1159: --Check return status
1160: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1161: x_msg_count := FND_MSG_PUB.count_msg;
1162: if x_msg_count = 1 then
1163: pa_interface_utils_pub.get_messages
1164: (p_encoded => FND_API.G_TRUE,
1165: p_msg_index => 1,

Line 1246: x_msg_count := FND_MSG_PUB.count_msg;

1242: WHEN FND_API.G_EXC_ERROR THEN
1243: IF (p_commit = FND_API.G_TRUE) THEN
1244: ROLLBACK to UPDATE_TASK;
1245: END IF;
1246: x_msg_count := FND_MSG_PUB.count_msg;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: WHEN OTHERS THEN
1249: IF (p_commit = FND_API.G_TRUE) THEN
1250: ROLLBACK to UPDATE_TASK;

Line 1252: x_msg_count := FND_MSG_PUB.count_msg;

1248: WHEN OTHERS THEN
1249: IF (p_commit = FND_API.G_TRUE) THEN
1250: ROLLBACK to UPDATE_TASK;
1251: END IF;
1252: x_msg_count := FND_MSG_PUB.count_msg;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: --put message
1255: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1256: p_procedure_name => 'UPDATE_TASK',

Line 1255: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1251: END IF;
1252: x_msg_count := FND_MSG_PUB.count_msg;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: --put message
1255: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1256: p_procedure_name => 'UPDATE_TASK',
1257: p_error_text => substrb(SQLERRM,1,240));
1258: -- RAISE;
1259: END UPDATE_TASK;

Line 1361: FND_MSG_PUB.initialize;

1357: END IF;
1358:
1359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1360: pa_debug.debug('Performing ID validations and conversions');
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363:
1364: --Check if there is any error
1365: l_msg_count := FND_MSG_PUB.count_msg;

Line 1365: l_msg_count := FND_MSG_PUB.count_msg;

1361: FND_MSG_PUB.initialize;
1362: END IF;
1363:
1364: --Check if there is any error
1365: l_msg_count := FND_MSG_PUB.count_msg;
1366: if l_msg_count > 0 then
1367: x_msg_count := l_msg_count;
1368: if x_msg_count = 1 then
1369: pa_interface_utils_pub.get_messages

Line 1423: x_msg_count := FND_MSG_PUB.count_msg;

1419: );
1420:
1421: --Check return status
1422: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1423: x_msg_count := FND_MSG_PUB.count_msg;
1424: if x_msg_count = 1 then
1425: pa_interface_utils_pub.get_messages
1426: (p_encoded => FND_API.G_TRUE,
1427: p_msg_index => 1,

Line 1477: x_msg_count := FND_MSG_PUB.count_msg;

1473: WHEN FND_API.G_EXC_ERROR THEN
1474: IF (p_commit = FND_API.G_TRUE) THEN
1475: ROLLBACK to DELETE_TASK;
1476: END IF;
1477: x_msg_count := FND_MSG_PUB.count_msg;
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: WHEN OTHERS THEN
1480: IF (p_commit = FND_API.G_TRUE) THEN
1481: ROLLBACK to DELETE_TASK;

Line 1483: x_msg_count := FND_MSG_PUB.count_msg;

1479: WHEN OTHERS THEN
1480: IF (p_commit = FND_API.G_TRUE) THEN
1481: ROLLBACK to DELETE_TASK;
1482: END IF;
1483: x_msg_count := FND_MSG_PUB.count_msg;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1486: p_procedure_name => 'DELETE_TASK',
1487: p_error_text => substrb(SQLERRM,1,240));

Line 1485: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1481: ROLLBACK to DELETE_TASK;
1482: END IF;
1483: x_msg_count := FND_MSG_PUB.count_msg;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1486: p_procedure_name => 'DELETE_TASK',
1487: p_error_text => substrb(SQLERRM,1,240));
1488: END DELETE_TASK;
1489:

Line 1584: fnd_msg_pub.initialize;

1580:
1581: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.Edit_Task_Structure');
1582:
1583: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1584: fnd_msg_pub.initialize;
1585: end if;
1586:
1587: /*IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
1588:

Line 1659: l_msg_count := FND_MSG_PUB.count_msg;

1655: p_wbs_record_version_number => p_wbs_record_version_number,
1656: x_return_status => x_return_status,
1657: x_msg_data => x_msg_data ); */
1658:
1659: l_msg_count := FND_MSG_PUB.count_msg;
1660:
1661: If l_msg_count > 0 THEN
1662: x_msg_count := l_msg_count;
1663: If l_msg_count = 1 THEN

Line 1695: l_msg_count := FND_MSG_PUB.count_msg;

1691: ,x_return_status => x_return_status
1692: ,x_msg_count => x_msg_count
1693: ,x_msg_data => x_msg_data );
1694:
1695: l_msg_count := FND_MSG_PUB.count_msg;
1696:
1697: --dbms_output.put_line( 'Edit Task structure. '||'After Indent Task '||'Count '|| l_msg_count );
1698:
1699: ELSIF p_edit_mode = 'OUTDENT'

Line 1725: l_msg_count := FND_MSG_PUB.count_msg;

1721:
1722: if (p_debug_mode = 'Y') then
1723: pa_debug.debug('Edit Task Structure PUB : checking message count');
1724: end if;
1725: l_msg_count := FND_MSG_PUB.count_msg;
1726:
1727: If l_msg_count > 0 THEN
1728: x_msg_count := l_msg_count;
1729: If l_msg_count = 1 THEN

Line 1760: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1756: THEN
1757: ROLLBACK TO Edit_Structure;
1758: END IF;
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1760: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1761: p_procedure_name => 'Edit_Task_Structure',
1762: p_error_text => SUBSTRB(SQLERRM,1,240));
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764:

Line 1778: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1774: THEN
1775: ROLLBACK TO Edit_Structure;
1776: END IF;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1779: p_procedure_name => 'Edit_Task_Structure',
1780: p_error_text => SUBSTRB(SQLERRM,1,240));
1781: RAISE;
1782:

Line 1882: fnd_msg_pub.initialize;

1878: pa_debug.debug('Move Task PUB : Initializing message stack.');
1879: end if;
1880: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.MOVE_TASK');
1881: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1882: fnd_msg_pub.initialize;
1883: end if;
1884:
1885: --dbms_output.put_line( 'Before name to id conv. ' );
1886: --commenting after discussing with Hubert and Sakthi.

Line 1994: l_msg_count := FND_MSG_PUB.count_msg;

1990: x_msg_data => x_msg_data ); */
1991:
1992: --dbms_output.put_line( 'After locking 1 ' );
1993:
1994: l_msg_count := FND_MSG_PUB.count_msg;
1995: IF l_msg_count > 0 THEN
1996: x_msg_count := l_msg_count;
1997: x_msg_data := x_msg_data;
1998: --dbms_output.put_line( 'x_msg_data '||x_msg_data );

Line 2009: l_msg_count := FND_MSG_PUB.count_msg;

2005: if (p_debug_mode = 'Y') then
2006: pa_debug.debug('Move Task PUB : checking message count');
2007: end if;
2008:
2009: l_msg_count := FND_MSG_PUB.count_msg;
2010:
2011: --dbms_output.put_line( 'After locking 3 ' );
2012:
2013: If l_msg_count > 0 THEN

Line 2050: l_msg_count := FND_MSG_PUB.count_msg;

2046:
2047: if (p_debug_mode = 'Y') then
2048: pa_debug.debug('Move Task PUB : checking message count');
2049: end if;
2050: l_msg_count := FND_MSG_PUB.count_msg;
2051:
2052:
2053: If l_msg_count > 0 THEN
2054: x_msg_count := l_msg_count;

Line 2089: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2085: THEN
2086: ROLLBACK TO Move;
2087: END IF;
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2089: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2090: p_procedure_name => 'Move_Task',
2091: p_error_text => SUBSTRB(SQLERRM,1,240));
2092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2093:

Line 2107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2103: THEN
2104: ROLLBACK TO Move;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2108: p_procedure_name => 'Move_Task',
2109: p_error_text => SUBSTRB(SQLERRM,1,240));
2110: RAISE;
2111:

Line 2215: fnd_msg_pub.initialize;

2211: pa_debug.debug('Copy Task PUB : Initializing message stack.');
2212: end if;
2213: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.COPY_TASK');
2214: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2215: fnd_msg_pub.initialize;
2216: end if;
2217:
2218: IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
2219:

Line 2333: l_msg_count := FND_MSG_PUB.count_msg;

2329: x_return_status => x_return_status,
2330: x_msg_data => x_msg_data ); */
2331:
2332:
2333: l_msg_count := FND_MSG_PUB.count_msg;
2334: IF l_msg_count > 0 THEN
2335: x_msg_count := l_msg_count;
2336: x_return_status := 'E';
2337: RAISE FND_API.G_EXC_ERROR;

Line 2396: l_msg_count := FND_MSG_PUB.count_msg;

2392:
2393: if (p_debug_mode = 'Y') then
2394: pa_debug.debug('Edit Task Structure PUB : checking message count');
2395: end if;
2396: l_msg_count := FND_MSG_PUB.count_msg;
2397:
2398:
2399: If l_msg_count > 0 THEN
2400: x_msg_count := l_msg_count;

Line 2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2429: THEN
2430: ROLLBACK TO Copy;
2431: END IF;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2434: p_procedure_name => 'Copy_Task',
2435: p_error_text => SUBSTRB(SQLERRM,1,240));
2436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2437:

Line 2451: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2447: THEN
2448: ROLLBACK TO Copy;
2449: END IF;
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2452: p_procedure_name => 'Copy_Task',
2453: p_error_text => SUBSTRB(SQLERRM,1,240));
2454: RAISE;
2455:

Line 2704: FND_MSG_PUB.initialize;

2700: l_debug_level3);
2701: END IF;
2702:
2703: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2704: FND_MSG_PUB.initialize;
2705: END IF;
2706:
2707: IF (p_commit = FND_API.G_TRUE) THEN
2708: savepoint SET_FIN_FLAG_WRAPPER_PUBLIC;

Line 2998: l_msg_count := Fnd_Msg_Pub.count_msg;

2994:
2995: WHEN FND_API.G_EXC_ERROR THEN
2996:
2997: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2998: l_msg_count := Fnd_Msg_Pub.count_msg;
2999:
3000: IF p_commit = FND_API.G_TRUE THEN
3001: ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC;
3002: END IF;

Line 3060: Fnd_Msg_Pub.add_exc_msg

3056: END IF;
3057: IF c_get_pa_record_version_number%ISOPEN THEN
3058: CLOSE c_get_pa_record_version_number;
3059: END IF;
3060: Fnd_Msg_Pub.add_exc_msg
3061: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3062: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3063: , p_error_text => x_msg_data);
3064:

Line 3097: Fnd_Msg_Pub.add_exc_msg

3093: IF c_get_pa_record_version_number%ISOPEN THEN
3094: CLOSE c_get_pa_record_version_number;
3095: END IF;
3096:
3097: Fnd_Msg_Pub.add_exc_msg
3098: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3099: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3100: , p_error_text => x_msg_data);
3101:

Line 3304: FND_MSG_PUB.initialize;

3300: l_proj_element_id_tbl.DELETE;
3301: l_fin_task_flag_tbl.DELETE;
3302:
3303: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306:
3307: IF (p_commit = FND_API.G_TRUE) THEN
3308: savepoint POPULATE_TEMP_TBL_PUB;

Line 3433: l_msg_count := Fnd_Msg_Pub.count_msg;

3429: EXCEPTION
3430: WHEN FND_API.G_EXC_ERROR THEN
3431:
3432: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3433: l_msg_count := Fnd_Msg_Pub.count_msg;
3434:
3435: IF p_commit = FND_API.G_TRUE THEN
3436: ROLLBACK TO POPULATE_TEMP_TABLE_PUB;
3437: END IF;

Line 3482: Fnd_Msg_Pub.add_exc_msg

3478:
3479: IF c_get_parents%ISOPEN THEN
3480: CLOSE c_get_parents;
3481: END IF;
3482: Fnd_Msg_Pub.add_exc_msg
3483: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3484: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3485: , p_error_text => x_msg_data);
3486:

Line 3512: Fnd_Msg_Pub.add_exc_msg

3508: IF c_get_parents%ISOPEN THEN
3509: CLOSE c_get_parents;
3510: END IF;
3511:
3512: Fnd_Msg_Pub.add_exc_msg
3513: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3514: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3515: , p_error_text => x_msg_data);
3516:

Line 3625: FND_MSG_PUB.initialize;

3621: l_debug_level3);
3622: END IF;
3623:
3624: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3625: FND_MSG_PUB.initialize;
3626: END IF;
3627:
3628: IF (p_commit = FND_API.G_TRUE) THEN
3629: savepoint SYNC_UP_WITH_FIN_PUBLIC;

Line 3723: l_msg_count := Fnd_Msg_Pub.count_msg;

3719:
3720: WHEN FND_API.G_EXC_ERROR THEN
3721:
3722: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3723: l_msg_count := Fnd_Msg_Pub.count_msg;
3724:
3725: IF p_commit = FND_API.G_TRUE THEN
3726: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3727: END IF;

Line 3759: Fnd_Msg_Pub.add_exc_msg

3755: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3756: END IF;
3757:
3758:
3759: Fnd_Msg_Pub.add_exc_msg
3760: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3761: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3762: , p_error_text => x_msg_data);
3763: IF l_debug_mode = 'Y' THEN

Line 3784: Fnd_Msg_Pub.add_exc_msg

3780: END IF;
3781:
3782:
3783:
3784: Fnd_Msg_Pub.add_exc_msg
3785: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3786: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3787: , p_error_text => x_msg_data);
3788: