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.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_MSG_PUB

Line 423: FND_MSG_PUB.initialize;

419:
420: -- Initialize message list if p_init_msg_list is set to TRUE.
421:
422: if FND_API.to_Boolean (p_init_msg_list) then
423: FND_MSG_PUB.initialize;
424: end if;
425:
426: p_return_status := FND_API.G_RET_STS_SUCCESS;
427:

Line 617: FND_MSG_PUB.Add;

613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
617: FND_MSG_PUB.Add;
618: end if;
619:
620: l_per_index := 1;
621:

Line 937: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

933:
934: when FND_API.G_EXC_ERROR then
935: rollback to Get_Position;
936: p_return_status := FND_API.G_RET_STS_ERROR;
937: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
938: p_data => p_msg_data);
939: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
940: p_data => p_msg_data);
941: message_token('POSITION_NAME',l_position_name );

Line 939: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

935: rollback to Get_Position;
936: p_return_status := FND_API.G_RET_STS_ERROR;
937: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
938: p_data => p_msg_data);
939: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
940: p_data => p_msg_data);
941: message_token('POSITION_NAME',l_position_name );
942: message_token('EMPLOYEE_NAME',l_employee_name );
943: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 948: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

944:
945: when FND_API.G_EXC_UNEXPECTED_ERROR then
946: rollback to Get_Position;
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
949: p_data => p_msg_data);
950: message_token('POSITION_NAME',l_position_name );
951: message_token('EMPLOYEE_NAME',l_employee_name );
952: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

955: --
956: ROLLBACK TO Get_Position ;
957: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: --
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
960: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
961: l_api_name);
962: END if;
963: --

Line 960: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

956: ROLLBACK TO Get_Position ;
957: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: --
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
960: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
961: l_api_name);
962: END if;
963: --
964:

Line 966: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

962: END if;
963: --
964:
965: --
966: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
967: p_data => p_msg_data );
968: --
969: message_token('POSITION_NAME',l_position_name );
970: message_token('EMPLOYEE_NAME',l_employee_name );

Line 1143: FND_MSG_PUB.initialize;

1139: end if;
1140:
1141: -- Initialize message list if p_init_msg_list is set to TRUE.
1142: if FND_API.to_Boolean (p_init_msg_list) then
1143: FND_MSG_PUB.initialize;
1144: end if;
1145: p_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: l_last_update_date := sysdate;

Line 1545: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1541: when FND_API.G_EXC_ERROR then
1542:
1543: rollback to Get_Salary;
1544: p_return_status := FND_API.G_RET_STS_ERROR;
1545: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1546: p_data => p_msg_data);
1547: message_token('SALARY_TYPE',l_salary_type );
1548: message_token('RATE_OR_PAYSCALE_NAME',l_rate_or_payscale_name );
1549: message_token('GRADE_NAME',l_grade_name );

Line 1558: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1554: when FND_API.G_EXC_UNEXPECTED_ERROR then
1555:
1556: rollback to Get_Salary;
1557: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1559: p_data => p_msg_data);
1560: message_token('SALARY_TYPE',l_salary_type );
1561: message_token('RATE_OR_PAYSCALE_NAME',l_rate_or_payscale_name );
1562: message_token('GRADE_NAME',l_grade_name );

Line 1571: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1567: when OTHERS then
1568:
1569: rollback to Get_Salary;
1570: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1572: p_data => p_msg_data);
1573:
1574: message_token('SALARY_TYPE',l_salary_type );
1575: message_token('RATE_OR_PAYSCALE_NAME',l_rate_or_payscale_name );

Line 1581: if FND_MSG_PUB.Check_Msg_Level

1577: message_token('GRADE_STEP',l_grade_step );
1578: message_token('GRADE_SEQUENCE',l_sequence);
1579: add_message('PSB', 'PSB_SALARY_DETAILS');
1580:
1581: if FND_MSG_PUB.Check_Msg_Level
1582: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1583: then
1584: FND_MSG_PUB.Add_Exc_Msg
1585: (p_pkg_name => G_PKG_NAME,

Line 1582: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1578: message_token('GRADE_SEQUENCE',l_sequence);
1579: add_message('PSB', 'PSB_SALARY_DETAILS');
1580:
1581: if FND_MSG_PUB.Check_Msg_Level
1582: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1583: then
1584: FND_MSG_PUB.Add_Exc_Msg
1585: (p_pkg_name => G_PKG_NAME,
1586: p_procedure_name => l_api_name);

Line 1584: FND_MSG_PUB.Add_Exc_Msg

1580:
1581: if FND_MSG_PUB.Check_Msg_Level
1582: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1583: then
1584: FND_MSG_PUB.Add_Exc_Msg
1585: (p_pkg_name => G_PKG_NAME,
1586: p_procedure_name => l_api_name);
1587: end if;
1588:

Line 1860: FND_MSG_PUB.initialize;

1856:
1857: -- Initialize message list if p_init_msg_list is set to TRUE.
1858:
1859: if FND_API.to_Boolean (p_init_msg_list) then
1860: FND_MSG_PUB.initialize;
1861: end if;
1862:
1863: p_return_status := FND_API.G_RET_STS_SUCCESS;
1864:

Line 2204: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2200:
2201: when FND_API.G_EXC_ERROR then
2202: rollback to Get_Employee;
2203: p_return_status := FND_API.G_RET_STS_ERROR;
2204: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2205: p_data => p_msg_data);
2206: message_token('POSITION_NAME',l_position_name );
2207: message_token('EMPLOYEE_NAME',l_employee_name );
2208: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 2216: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2212: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: message_token('POSITION_NAME',l_position_name );
2214: message_token('EMPLOYEE_NAME',l_employee_name );
2215: add_message('PSB', 'PSB_POSITION_DETAILS');
2216: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2217: p_data => p_msg_data);
2218:
2219:
2220: when OTHERS then

Line 2223: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2219:
2220: when OTHERS then
2221: rollback to Get_Employee;
2222: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2224: p_data => p_msg_data);
2225: message_token('POSITION_NAME',l_position_name );
2226: message_token('EMPLOYEE_NAME',l_employee_name );
2227: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 2229: if FND_MSG_PUB.Check_Msg_Level

2225: message_token('POSITION_NAME',l_position_name );
2226: message_token('EMPLOYEE_NAME',l_employee_name );
2227: add_message('PSB', 'PSB_POSITION_DETAILS');
2228:
2229: if FND_MSG_PUB.Check_Msg_Level
2230: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: then
2232: FND_MSG_PUB.Add_Exc_Msg
2233: (p_pkg_name => G_PKG_NAME,

Line 2230: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2226: message_token('EMPLOYEE_NAME',l_employee_name );
2227: add_message('PSB', 'PSB_POSITION_DETAILS');
2228:
2229: if FND_MSG_PUB.Check_Msg_Level
2230: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: then
2232: FND_MSG_PUB.Add_Exc_Msg
2233: (p_pkg_name => G_PKG_NAME,
2234: p_procedure_name => l_api_name);

Line 2232: FND_MSG_PUB.Add_Exc_Msg

2228:
2229: if FND_MSG_PUB.Check_Msg_Level
2230: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: then
2232: FND_MSG_PUB.Add_Exc_Msg
2233: (p_pkg_name => G_PKG_NAME,
2234: p_procedure_name => l_api_name);
2235: end if;
2236:

Line 2490: FND_MSG_PUB.initialize;

2486:
2487: -- Initialize message list if p_init_msg_list is set to TRUE.
2488:
2489: if FND_API.to_Boolean (p_init_msg_list) then
2490: FND_MSG_PUB.initialize;
2491: end if;
2492:
2493: p_return_status := FND_API.G_RET_STS_SUCCESS;
2494:

Line 2755: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2751: /* Bug 3677529 commenting out the following exception clauses
2752: when FND_API.G_EXC_ERROR then
2753: rollback to Get_Costing;
2754: p_return_status := FND_API.G_RET_STS_ERROR;
2755: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2756: p_data => p_msg_data);
2757: message_token('POSITION_NAME',l_position_name );
2758: message_token('EMPLOYEE_NAME',l_employee_name );
2759: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 2764: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2760:
2761: when FND_API.G_EXC_UNEXPECTED_ERROR then
2762: rollback to Get_Costing;
2763: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2764: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2765: p_data => p_msg_data);
2766: message_token('POSITION_NAME',l_position_name );
2767: message_token('EMPLOYEE_NAME',l_employee_name );
2768: add_message('PSB', 'PSB_POSITION_DETAILS'); */

Line 2773: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2769:
2770: when OTHERS then
2771: rollback to Get_Costing;
2772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2773: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2774: p_data => p_msg_data);
2775: message_token('POSITION_NAME',l_position_name );
2776: message_token('EMPLOYEE_NAME',l_employee_name );
2777: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 2779: if FND_MSG_PUB.Check_Msg_Level

2775: message_token('POSITION_NAME',l_position_name );
2776: message_token('EMPLOYEE_NAME',l_employee_name );
2777: add_message('PSB', 'PSB_POSITION_DETAILS');
2778:
2779: if FND_MSG_PUB.Check_Msg_Level
2780: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2781: then
2782: FND_MSG_PUB.Add_Exc_Msg
2783: (p_pkg_name => G_PKG_NAME,

Line 2780: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2776: message_token('EMPLOYEE_NAME',l_employee_name );
2777: add_message('PSB', 'PSB_POSITION_DETAILS');
2778:
2779: if FND_MSG_PUB.Check_Msg_Level
2780: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2781: then
2782: FND_MSG_PUB.Add_Exc_Msg
2783: (p_pkg_name => G_PKG_NAME,
2784: p_procedure_name => l_api_name);

Line 2782: FND_MSG_PUB.Add_Exc_Msg

2778:
2779: if FND_MSG_PUB.Check_Msg_Level
2780: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2781: then
2782: FND_MSG_PUB.Add_Exc_Msg
2783: (p_pkg_name => G_PKG_NAME,
2784: p_procedure_name => l_api_name);
2785: end if;
2786:

Line 2886: FND_MSG_PUB.initialize;

2882:
2883: -- Initialize message list if p_init_msg_list is set to TRUE.
2884:
2885: if FND_API.to_Boolean (p_init_msg_list) then
2886: FND_MSG_PUB.initialize;
2887: end if;
2888:
2889: p_return_status := FND_API.G_RET_STS_SUCCESS;
2890:

Line 3175: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3171: /* Bug 3677529 commented out the following exception clauses
3172: when FND_API.G_EXC_ERROR then
3173: rollback to Get_LD_Schedule;
3174: p_return_status := FND_API.G_RET_STS_ERROR;
3175: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3176: p_data => p_msg_data);
3177:
3178: when FND_API.G_EXC_UNEXPECTED_ERROR then
3179: rollback to Get_LD_Schedule;

Line 3181: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3177:
3178: when FND_API.G_EXC_UNEXPECTED_ERROR then
3179: rollback to Get_LD_Schedule;
3180: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3181: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3182: p_data => p_msg_data);
3183: */
3184:
3185: when OTHERS then

Line 3188: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3184:
3185: when OTHERS then
3186: rollback to Get_LD_Schedule;
3187: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3188: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3189: p_data => p_msg_data);
3190: /* Bug 3677529 Start */
3191: IF FND_MSG_PUB.Check_Msg_Level
3192: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3191: IF FND_MSG_PUB.Check_Msg_Level

3187: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3188: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3189: p_data => p_msg_data);
3190: /* Bug 3677529 Start */
3191: IF FND_MSG_PUB.Check_Msg_Level
3192: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3193: THEN
3194: FND_MSG_PUB.Add_Exc_Msg
3195: (p_pkg_name => G_PKG_NAME,

Line 3192: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3188: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3189: p_data => p_msg_data);
3190: /* Bug 3677529 Start */
3191: IF FND_MSG_PUB.Check_Msg_Level
3192: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3193: THEN
3194: FND_MSG_PUB.Add_Exc_Msg
3195: (p_pkg_name => G_PKG_NAME,
3196: p_procedure_name => l_api_name);

Line 3194: FND_MSG_PUB.Add_Exc_Msg

3190: /* Bug 3677529 Start */
3191: IF FND_MSG_PUB.Check_Msg_Level
3192: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3193: THEN
3194: FND_MSG_PUB.Add_Exc_Msg
3195: (p_pkg_name => G_PKG_NAME,
3196: p_procedure_name => l_api_name);
3197: END IF;
3198: /* Bug 3677529 End */

Line 3667: FND_MSG_PUB.initialize;

3663:
3664: -- Initialize message list if p_init_msg_list is set to TRUE.
3665:
3666: if FND_API.to_Boolean (p_init_msg_list) then
3667: FND_MSG_PUB.initialize;
3668: end if;
3669:
3670: p_return_status := FND_API.G_RET_STS_SUCCESS;
3671:

Line 4290: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4286: end if;
4287:
4288: rollback to Get_Attributes;
4289: p_return_status := FND_API.G_RET_STS_ERROR;
4290: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4291: p_data => p_msg_data);
4292: message_token('ATTRIBUTE_NAME',l_attribute_name );
4293: message_token('DEFINITION_TYPE',l_definition_type );
4294: message_token('DEFINITION_STRUCTURE',l_definition_structure);

Line 4319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4315: end if;
4316:
4317: rollback to Get_Attributes;
4318: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4319: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4320: p_data => p_msg_data);
4321: message_token('ATTRIBUTE_NAME',l_attribute_name );
4322: message_token('DEFINITION_TYPE',l_definition_type );
4323: message_token('DEFINITION_STRUCTURE',l_definition_structure);

Line 4348: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4344: end if;
4345:
4346: rollback to Get_Attributes;
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4349: p_data => p_msg_data);
4350: message_token('ATTRIBUTE_NAME',l_attribute_name );
4351: message_token('DEFINITION_TYPE',l_definition_type );
4352: message_token('DEFINITION_STRUCTURE',l_definition_structure);

Line 4356: if FND_MSG_PUB.Check_Msg_level

4352: message_token('DEFINITION_STRUCTURE',l_definition_structure);
4353: message_token('DEFINITION_TABLE',l_definition_table);
4354: message_token('DEFINITION_COLUMN',l_definition_column);
4355: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
4356: if FND_MSG_PUB.Check_Msg_level
4357: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4358: then
4359: FND_MSG_PUB.Add_Exc_Msg
4360: (p_pkg_name => G_PKG_NAME,

Line 4357: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4353: message_token('DEFINITION_TABLE',l_definition_table);
4354: message_token('DEFINITION_COLUMN',l_definition_column);
4355: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
4356: if FND_MSG_PUB.Check_Msg_level
4357: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4358: then
4359: FND_MSG_PUB.Add_Exc_Msg
4360: (p_pkg_name => G_PKG_NAME,
4361: p_procedure_name => l_api_name);

Line 4359: FND_MSG_PUB.Add_Exc_Msg

4355: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
4356: if FND_MSG_PUB.Check_Msg_level
4357: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4358: then
4359: FND_MSG_PUB.Add_Exc_Msg
4360: (p_pkg_name => G_PKG_NAME,
4361: p_procedure_name => l_api_name);
4362: end if;
4363:

Line 4738: FND_MSG_PUB.initialize;

4734:
4735: -- Initialize message list if p_init_msg_list is set to TRUE.
4736:
4737: if FND_API.to_Boolean (p_init_msg_list) then
4738: FND_MSG_PUB.initialize;
4739: end if;
4740:
4741: p_return_status := FND_API.G_RET_STS_SUCCESS;
4742:

Line 6215: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

6211: end if;
6212:
6213: rollback to Get_Employee_Attributes;
6214: p_return_status := FND_API.G_RET_STS_ERROR;
6215: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6216: p_data => p_msg_data);
6217: message_token('POSITION_NAME',l_position_name );
6218: message_token('EMPLOYEE_NAME',l_employee_name );
6219: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 6260: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

6256: end if;
6257:
6258: rollback to Get_Employee_Attributes;
6259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6260: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6261: p_data => p_msg_data);
6262: message_token('POSITION_NAME',l_position_name );
6263: message_token('EMPLOYEE_NAME',l_employee_name );
6264: add_message('PSB', 'PSB_POSITION_DETAILS');

Line 6304: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

6300: dbms_sql.close_cursor(v_jcursorid);
6301: end if;
6302: rollback to Get_Employee_Attributes;
6303: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6304: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6305: p_data => p_msg_data);
6306:
6307: message_token('POSITION_NAME',l_position_name );
6308: message_token('EMPLOYEE_NAME',l_employee_name );

Line 6317: if FND_MSG_PUB.Check_Msg_Level

6313: message_token('DEFINITION_STRUCTURE',l_definition_structure);
6314: message_token('DEFINITION_TABLE',l_definition_table);
6315: message_token('DEFINITION_COLUMN',l_definition_column);
6316: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
6317: if FND_MSG_PUB.Check_Msg_Level
6318: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6319: then
6320: FND_MSG_PUB.Add_Exc_Msg
6321: (p_pkg_name => G_PKG_NAME,

Line 6318: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6314: message_token('DEFINITION_TABLE',l_definition_table);
6315: message_token('DEFINITION_COLUMN',l_definition_column);
6316: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
6317: if FND_MSG_PUB.Check_Msg_Level
6318: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6319: then
6320: FND_MSG_PUB.Add_Exc_Msg
6321: (p_pkg_name => G_PKG_NAME,
6322: p_procedure_name => l_api_name);

Line 6320: FND_MSG_PUB.Add_Exc_Msg

6316: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
6317: if FND_MSG_PUB.Check_Msg_Level
6318: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6319: then
6320: FND_MSG_PUB.Add_Exc_Msg
6321: (p_pkg_name => G_PKG_NAME,
6322: p_procedure_name => l_api_name);
6323: end if;
6324:

Line 6597: if FND_MSG_PUB.Check_Msg_Level

6593:
6594: when OTHERS then
6595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6596:
6597: if FND_MSG_PUB.Check_Msg_Level
6598: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6599: then
6600: FND_MSG_PUB.Add_Exc_Msg
6601: (p_pkg_name => G_PKG_NAME,

Line 6598: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6594: when OTHERS then
6595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6596:
6597: if FND_MSG_PUB.Check_Msg_Level
6598: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6599: then
6600: FND_MSG_PUB.Add_Exc_Msg
6601: (p_pkg_name => G_PKG_NAME,
6602: p_procedure_name => l_api_name);

Line 6600: FND_MSG_PUB.Add_Exc_Msg

6596:
6597: if FND_MSG_PUB.Check_Msg_Level
6598: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6599: then
6600: FND_MSG_PUB.Add_Exc_Msg
6601: (p_pkg_name => G_PKG_NAME,
6602: p_procedure_name => l_api_name);
6603: end if;
6604: End Check_Reentry;

Line 6818: if FND_MSG_PUB.Check_Msg_Level

6814: Close C_Reenter_Upd;
6815: end if;
6816: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6817:
6818: if FND_MSG_PUB.Check_Msg_Level
6819: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6820: then
6821: FND_MSG_PUB.Add_Exc_Msg
6822: (p_pkg_name => G_PKG_NAME,

Line 6819: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6815: end if;
6816: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6817:
6818: if FND_MSG_PUB.Check_Msg_Level
6819: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6820: then
6821: FND_MSG_PUB.Add_Exc_Msg
6822: (p_pkg_name => G_PKG_NAME,
6823: p_procedure_name => l_api_name);

Line 6821: FND_MSG_PUB.Add_Exc_Msg

6817:
6818: if FND_MSG_PUB.Check_Msg_Level
6819: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6820: then
6821: FND_MSG_PUB.Add_Exc_Msg
6822: (p_pkg_name => G_PKG_NAME,
6823: p_procedure_name => l_api_name);
6824: end if;
6825:

Line 7103: if FND_MSG_PUB.Check_Msg_Level

7099: end if;
7100:
7101: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102:
7103: if FND_MSG_PUB.Check_Msg_Level
7104: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7105: then
7106: FND_MSG_PUB.Add_Exc_Msg
7107: (p_pkg_name => G_PKG_NAME,

Line 7104: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7100:
7101: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102:
7103: if FND_MSG_PUB.Check_Msg_Level
7104: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7105: then
7106: FND_MSG_PUB.Add_Exc_Msg
7107: (p_pkg_name => G_PKG_NAME,
7108: p_procedure_name => l_api_name);

Line 7106: FND_MSG_PUB.Add_Exc_Msg

7102:
7103: if FND_MSG_PUB.Check_Msg_Level
7104: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7105: then
7106: FND_MSG_PUB.Add_Exc_Msg
7107: (p_pkg_name => G_PKG_NAME,
7108: p_procedure_name => l_api_name);
7109: end if;
7110:

Line 7207: FND_MSG_PUB.initialize;

7203:
7204: -- Initialize message list if p_init_msg_list is set to TRUE.
7205:
7206: if FND_API.to_Boolean (p_init_msg_list) then
7207: FND_MSG_PUB.initialize;
7208: end if;
7209:
7210:
7211: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7334: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7330: when FND_API.G_EXC_ERROR then
7331:
7332: rollback to Validate_Attribute_Mapping;
7333: p_return_status := FND_API.G_RET_STS_ERROR;
7334: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7335: p_data => p_msg_data);
7336: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7337: p_data => p_msg_data);
7338:

Line 7336: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7332: rollback to Validate_Attribute_Mapping;
7333: p_return_status := FND_API.G_RET_STS_ERROR;
7334: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7335: p_data => p_msg_data);
7336: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7337: p_data => p_msg_data);
7338:
7339: when FND_API.G_EXC_UNEXPECTED_ERROR then
7340: rollback to Validate_Attribute_Mapping;

Line 7342: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7338:
7339: when FND_API.G_EXC_UNEXPECTED_ERROR then
7340: rollback to Validate_Attribute_Mapping;
7341: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7342: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7343: p_data => p_msg_data);
7344:
7345: WHEN OTHERS THEN
7346: --

Line 7350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7346: --
7347: ROLLBACK TO Validate_Attribute_Mapping ;
7348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7349: --
7350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
7352: l_api_name);
7353: END if;
7354: --

Line 7351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

7347: ROLLBACK TO Validate_Attribute_Mapping ;
7348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7349: --
7350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
7352: l_api_name);
7353: END if;
7354: --
7355:

Line 7357: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

7353: END if;
7354: --
7355:
7356: --
7357: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
7358: p_data => p_msg_data );
7359: --
7360:
7361: END Validate_Attribute_Mapping;

Line 7555: FND_MSG_PUB.Add;

7551: end loop;
7552:
7553: end if;
7554:
7555: FND_MSG_PUB.Add;
7556:
7557: end if;
7558:
7559: -- Clear Message Token stack